iPaaS Flow Variable reference in SET FROM JSON Script

We have a flow with a "Set [ ] from Json" steps, and then inside the Script it makes a reference like:

var data = $ds$360;

How do we associate a specific parameter/variable or know what parameter/variable is referenced to $d2$360 in this example.

parameters variables json script iPaaS

Asked by Will Tonkin on Wed 5/17/23 10:28 AM

Answer (1)

Mark Sayers Wed 5/17/23 11:32 AM

Hello Will,

A script in this case probably refers to the exported JSON, which has a bunch of things like $ds$360.
Those names are only set and interpreted by iPaaS on export or import - and are (typically) not visible in the builder.
There is no good way to control these in the export, and the only way to see what it refers to would be to import it into another flow.

We could verify this if you wanted to identify the specific flow and application it lives in, but in general we would advise *not* to modify the JSON that comes out of flows. It's for iPaaS to utilize that data, not for direct modification of the JSON.

Sincerely,
Mark Sayers
Sr Support Consultant, CS

No feedback

Mark,

Thanks for the quick response.

This gives some insight, but where this particular script is used is following a SQL query connector step. This script was created by Michael Wolski in our iPaaS Onboarding flow.

We are currently creating our own Student OnBoarding flow, using much of what Michael created for the Employee Onboarding as a reference.

So what I need to know is how do I in a SET [ ] FROM JSON step, script do like: var SomeData = the result of the SQL Query Connector Step?

Thanks,

Will - Will Tonkin Wed 5/17/23 11:51 AM

I'll ask about that for you. - Mark Sayers Wed 5/17/23 12:05 PM

I'm curious about the outcome as well; in my case I'm needing to pull the result of a delimited file "Get Rows" operation to do some more advanced analytics on certain datapoints. - Christopher Myers Tue 1/30/24 2:46 PM