Salesforce Integration with ServiceNow using Flow designer

[Anamika G V]

Hi All,

I am trying to integrate Servicenow with Salesforce and I am facing below mentioned issues. 

I am calling an API and with that I am getting some records and that are stored in response body using spoke and flows. Now I want to extract all the values from response body and set that value in one table. Please help me that how I can extract that values from response body and set that value in our tables.

I have configured a flow to get record in account table. But there are issues with flow execution. Please correct if the flow configuration is wrong.

Any help is much appreciated.

Regards,

Anamika

[Community Alums]

Hi,

you should provide more information on the execution issues, since it is difficult to say what is wrong without seeing anything.
In general, spoke action should provide retrieved data in a form of data pills, that can be dragged into respective fields in Create or Update record action. In some cases, you will need to further parse the data (usually in JSON or XML format).

If this answer helped you, please, mark this answer as helpful.

[Anamika G V]

Hi Ondrej,

We are trying SFDC - Servicenow integration via Integration Hub. Please find the below details.

Attached is the screenshot of Action for getting account details. I am able to fetch the data successfully from Salesforce end using custom spoke action. Also wanted to know how to store data in Servicenow table. Please correct if the method I used in this flow is wrong - I am stuck at this point.

We need a method to get the account details from this action so that it can be mapped to corresponding account record in servicenow. 

Regards,

Anamika

[ElijahStownton]

To extract values from the response body and set them in a table, parse the API response in your flow. Use the JSON parser or a similar function to extract specific values. If there are issues with flow execution, verify your API call configuration and ensure the response matches the expected format. For complex integrations, consider using a tool like Skyvia for easier data mapping and automation.

[Marwan_]

Hi @Anamika G V ,

Please have a look here: https://docs.servicenow.com/bundle/sandiego-application-development/page/administer/flow-designer/co...

and you might also be interested in this series that goes through how to set this up step by step:

May I also suggest using a solution that allows you to set up a connection and be up and running in no time.

Have a look at Exalate. As it comes pre-configured with some basic configuration and allows you to sync pretty much anything between the two platforms you are integrating.