Data Source REST call with Integration Hub / Flow Designer

[Kim Sullivan]

I'm running an Import using the REST (IntegrationHub) type in Data Source.  I've created my Request action Flow Designer step.  All is working great.... EXCEPT.

I need to be able to access one of my outputs from the Data Source Request - Enabling pre-processing script.  Its the only place besides the REST URL that is storing my user ID value.

Anyone know how I can get it and push it into my transform?

.

[Pradeep Sharma]

Hello Kim,

I am assuming you need to store ID value based on source input value? Is this information available in import set table as part of source field? If yes, then we can move this logic as part of transform script.

- Pradeep Sharma

[Kim Sullivan · Accepted solution]

Hey Pradeep... thanks for the response.  In this case I ended up adding odata.metadata=full to my Accept parameter.  That gave me the ID I needed at the beginning of each row.  I had to do some extra .split() and .replace() work, but I'm all set now.

Thanks!

[Pradeep Sharma]

Thanks for the update Kim.

Let me know if that answered your question. If so, please mark response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list. 

- Pradeep Sharma