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

[salesforce123]

The integration between Salesforce and ServiceNow using Flow Designer allows for efficient data synchronization and automation between the two platforms. Flow Designer, a visual workflow tool in Salesforce, enables the creation of seamless connections and streamlined workflows without extensive coding.

With this integration, you can establish bi-directional data exchange between Salesforce and ServiceNow, ensuring that relevant information is synchronized between the two systems. For instance, you can automatically create ServiceNow incidents from Salesforce cases or update Salesforce records based on changes in ServiceNow.

Flow Designer provides a user-friendly interface to configure the integration, mapping fields and data between corresponding objects in Salesforce and ServiceNow. You can define data transformations, validations, and business rules to ensure accurate and consistent data transfer.

Furthermore, Flow Designer offers a range of advanced capabilities, including decision elements, loops, and error handling, empowering you to design complex integration logic. You can leverage Salesforce platform features like process automation and user interactions within the flows, enhancing the integration's functionality and adaptability to specific business needs.

By integrating Salesforce and ServiceNow using Flow Designer, organizations can streamline processes, improve data integrity, and enhance collaboration across teams. This integration enables increased productivity, better customer service, and a more synchronized view of customer information across both platforms.

[Mathieu Lepoutr]

Hi Anamika

Please verify that the integration points are properly defined and that any required authentication or access permissions are in place. 

But I have a better option to extract values from the response body of an API call and set those values in a table, you can leverage the capabilities of Exalate. As an experienced user of Exalate, I have utilized its features to handle similar use cases and they work seamlessly 

[Anamika G V]

Hi All,

Thanks for your responses. 

This is the error I am getting when trying to run the flow.

Th flow is in Salesforce spoke application and Account table is in Customer Service application. Is it required to have both table and flow to be in same scope to achieve this?

Regards,

Anamika

[Mathieu Lepoutr]

Hi @Anamika G V 

To extract values from the response body of an API call and set them in a table within ServiceNow, you can follow these steps:

1. Analyze the API Response: Review the structure of the API response body to understand the data format and how the values are organized. Identify the specific values you need to extract and set in your table.

2. Parse the Response Body: Use ServiceNow scripting capabilities, such as JavaScript, to parse the API response body. You can leverage JSON parsing techniques to extract the desired values. Parse the response body and store the extracted values in variables.

3. Set Values in the Table: Once you have extracted the desired values, you can use ServiceNow APIs or scripting to set those values in your target table. Use appropriate methods, such as GlideRecord, to access the table and update the records with the extracted values.

Regarding the flow execution issues, it would be helpful to review the specific configuration of your flow. Check if the flow is correctly set up to retrieve records from the account table. Verify that the necessary conditions, filters, and mappings are properly configured. Debug any error messages or logs to identify and correct any misconfigurations.

While considering solutions for your integration needs, Exalate could be an option to explore.