Response Mapping the response from an API Call.

Anek Porwal Strategic Partner NetSuite Integration Whiz

• June 03, 2022 06:07
• Edited

Hello,
To give you a gist of my flow, I am sending some data from a record to an API.
When the data is processed and a success_id is sent from the API.
I want to store that success id in the record.
How can I do the Response Mapping?

Let's take for example:
The response from an API looks like this.
{
"success_id" : "12345"
}

Now in the Response Mapping, should the Mappings be like?
success_id -> success_id (Data flow to Netsuite)
(or)
data[0].sucess_id -> success_id 


Any help would be appreciated.

 

0

• 

  Scott Henderson CTO

  • June 05, 2022 16:54

  

  

  

  There are a couple ways to accomplish this.

  Most APIs will return an 'id' type field when importing new data, and we have a field in the import itself to configure this, and then you can simply reference the 'id' field in your response mapping.  Hopefully the following pics will help illustrate this.

  

  

   

  0
• 

  Scott Henderson CTO

  • June 05, 2022 16:57

  

  

  

  The other option is to use the '_json' field in the response mapping.  The '_json' field is basically a container variable that we use to store all the response fields that were returned by any API for a successful request. You can access any field that the API returns.

  

  0
• 

  Anek Porwal Strategic Partner NetSuite Integration Whiz

  • June 05, 2022 21:52

  

  

  Hello Scott,
  Thank you for taking out your time & replying to me.
  I have used _json field for mapping response data from API call.
  No luck the data is neither showing in the Debug Connections nor updating.

  0
• 

  Scott Henderson CTO

  • June 06, 2022 00:36

  

  

  

  I recommend getting help from support. This should be very easy to solve, and most likely there is a path that is not getting set correctly.

  0

Please sign in to leave a comment.