Skip to main content
Solved

IFS REST call output values are not fetching in the workflow

  • December 5, 2023
  • 3 replies
  • 230 views

Forum|alt.badge.img+6

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)

3 replies

Forum|alt.badge.img+7
  • Hero (Employee)
  • 67 replies
  • Answer
  • December 6, 2023

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+6
  • Author
  • Sidekick (Partner)
  • 27 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.