{{ transformations:ServiceNowCommandAction.png}} ====== UPDATE/DELETE RECORDS IN SERVICENOW ====== Category: Workflow / App/Cloud\\ \\ =====Description===== This action updates or deletes records in a ServiceNow table. \\ ===== Action settings ===== ^ Setting ^ Description ^ |Connector*|Select a configured [[connectors:servicenow|ServiceNow connector]], or build one by selecting //Add connector//.| |Table1|Enter, or use the "Pick table" button to browse through and select, the ServiceNow table to update or delete records in.| |Command|Select whether records are updated or deleted within the ServiceNow table. Options: //Update records// or //Delete records//.| |ServiceNow record IDs|Select the column in the current dataset that contains the IDs of the records to be updated/deleted.| * Setting can be specified using a [[:parameters|parameter]].\\ 1 Setting can be specified using a [[:parameters|parameter]] or the first value of a column. \\ ====Update records settings==== ^Setting ^Description ^ |Result handling|Choose how EasyMorph will handle instances when rows fail to be updated. Options: //Fail the action if a row fails to export// (the workflow stops and an action error is displayed), //Return a list of rows that failed to export// (the workflow continues, but the current dataset is a list of rows that could not be updated), or //Return only successful rows// (the current dataset becomes a list of the rows that were successfully updated).| |Field names in ServiceNow|Select whether the current EasyMorph dataset's column names align with the ServiceNow field names (//Same as EasyMorph// option), or whether the current dataset's columns need to be mapped to the ServiceNow fields (//Other//, and map EasyMorph columns to ServiceNow fields).| \\ ====Delete records settings==== ^Setting ^Description ^ |Error handling|Choose how EasyMorph will handle instances when rows fail to be deleted. Options: //Fail if a row can't be deleted// (the workflow stops and an action error is displayed), //Warn if a row can't be deleted// (the workflow continues, but a column is appended to the dataset table which holds warning messages for any rows that couldn't be deleted), or //Return rows that failed to be deleted// (the workflow continues, but the current dataset is a list of rows that could not be deleted).| \\ =====See also===== *[[transformations:exportservicenow|Export to ServiceNow]] *[[transformations:importservicenow|Import from ServiceNow]]