Skip to main content

Consuming a staging table endpoint & transform map using REST

whilst below works, developer site actually recommends the format:
/api/now/import/<staging table_name>

https://developer.servicenow.com/app.do#!/rest_api_doc?v=kingston&id=c_ImportSetAPI

-------------------


web service endpoint created in a remote ServiceNow instance via system web services> create new,
where the staging table name is u_staging_table_xyz and the requests are processed to the target table via a transform map

SOAP wsdl to consume from another ServiceNow instance might be

    https://<servicenowinstance>.service-now.com/u_staging_table_xyz.do?WSDL

format for consuming this on REST would be:

    https://<servicenowinstance>.service-now.com/api/now/table/u_staging_table_xyz 



Example test harness for a POST operation

 go to REST messages and create a new REST message as a test harness, and create a new http POST method:




set up a basic authentication profile and configure the authentication profile to use as credentials (use a test user in the target instance with the REST role) below example highlights how to pull in variable substitutions into the content using "field_name": "${variable_sub}", format




[copy JSON:
{
"u_code": "${u_code}",
"u_short_description": "this is a test",
"u_vendor_reference": "${u_vendor_reference}",
"u_vendor_reference_sys_id": "c0d2d2b2db2ce7804735323239961993",
"u_short_description": "test",
"u_work_notes": "test update",
"u_state": "15",
"u_number": "${u_number}",
"u_caller_id": ""

}

note: the transform map might be configured to coalesce on the 3rd party reference number and to reject updates if the u_number element is not populated with a pre-existing number
]

Comments

Popular posts from this blog

Get URL Parameter - server side script (portal or classic UI)

Classic UI : var sURL_editparam = gs . action . getGlideURI (). getMap (). get ( ' sysparm_aparameter ' ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); } Portal : var sURL_editparam = $sp . getParameter ( " sysparm_aparameter " ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); }

ServiceNow check for null or nil or empty (or not)

Haven't tested these all recently within global/local scopes, so feel free to have a play! option 1 use an encoded query embedded in the GlideRecord , e.g.  var grProf = new GlideRecord ( 'x_cls_clear_skye_i_profile' ); grProf . addQuery ( 'status=1^ owner=NULL ' ); grProf . query (); even better use the glideRecord  addNotNullQuery or addNullQuery option 2 JSUtil.nil / notNil (this might be the most powerful. See this link ) example: if ( current . operation () == 'insert' && JSUtil . notNil ( current . parent ) && ! current . work_effort . nil ())  option 3 there might be times when you need to get inside the GlideRecord and perform the check there, for example if the code goes down 2 optional routes depending on null / not null can use gs.nil : var grAppr = new GlideRecord ( 'sysapproval_approver' ); var grUser = new GlideRecord ( 'sys_user' ); if ( grUser . get ( 'sys_id' , current . approver )){