ServiceNow and Smartsheet BRIDGE integration

yh374

Hi,

I am trying to bring all records from a table in ServiceNow into my Smartsheet. All field names align and I am able to get the record from ServiceNow but unable to send that data into an existing Smartsheet.

I did get it to add one row from ServiceNow but that's only if I reference the row specifically in the Key and Value fields. I want to be able to reference all the records in ServiceNow and add them into Smartsheet as a one-time pull and then have it automatically bring in new rows as new records are made in ServiceNow table. Could anyone assist?

Current workflow:

Key#1: Name
Value#1: {{states.startstate.servicenow.get_records.data.Name}}

Georgie

Hi @yh374,

I believe you’ll need to create child workflows for each row you want to add. However, if you have a large number of rows, you’ll need to use JavaScript to streamline your workflow - I’d recommend taking a look at this comment for @Brian_Richardson's explanation of updating multiple rows at once, since it’ll likely be similar for adding multiple rows at once: Bridge | How to Find Rows With Status & Delete Them.

For more information about creating child workflows, take a look here: Use child workflows to manage complex processes.

I’d also recommend reviewing the following related threads:

• How to read and store multiple rows of data using Bridge?
• Bridge: Add row for every sheet

Hope that points you in the right direction!

Georgie

Brian_Richardson

Thanks for the callout @Georgie

Here’s some more examples using JavaScript and child workflows to push multiple row updates at once:

https://community.smartsheet.com/discussion/131140/bridge-examples-including-javascript

https://community.smartsheet.com/discussion/97621/use-javascript-in-bridge-to-efficiently-import-data-from-an-api#latest