Skip to main content
Solved

IFS REST call output values are not fetching in the workflow


Forum|alt.badge.img+5

Hi,

I’m trying to get row ids using an IFS REST call as below and not fetching values as expected in the workflow. When I run the Get sheets call in Postman I get results that show row ids.

 

Many thanks for your inputs on this issue.

Best regards,

Uvini

Best answer by Buddhi Gunasekara

Workflow uses JsonPath(A query language for JSON) to access response variables. 
It seems your JsonPath expression is not pointing to what you want. For example, if you want to get columns.id try something like 
$.columns[0].id. (Because columns is an Array and you need to specify which array object you need id of)

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+7

Workflow uses JsonPath(A query language for JSON) to access response variables. 
It seems your JsonPath expression is not pointing to what you want. For example, if you want to get columns.id try something like 
$.columns[0].id. (Because columns is an Array and you need to specify which array object you need id of)


Forum|alt.badge.img+5
  • Author
  • Sidekick (Partner)
  • 22 replies
  • December 6, 2023

@Buddhi Gunasekara  Is it possible to obtain the entire JSON response in a single variable(without pointing to one response variable)?


Forum|alt.badge.img+7

Yes. You just have to use JsonPath expression $
Then the whole response will be assigned to the variable you specify.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings