Forum Discussion

swright's avatar
swright
New Contributor III
6 years ago
Solved

What is the best way to loop through data from a file... like an csv?

I have a csv file with person ID numbers in one column. I need to use the id number to act on person records in the cloud via REST. What is the best way to setup a pipeline to get an ID, do some pr...
  • sg_sripathi's avatar
    sg_sripathi
    6 years ago

    @swright, if you refer to below pipeline. It will make two REST API call to two different end point (URL constructed using input) and with HTTP body content as you see in the example. So basically the REST snap will take care of processing each document for you.

swright's avatar
swright
New Contributor III
6 years ago

Hi Pooja,

I tried that with File Reader > CSV Parser > Sequence > Mapper > Pipeline Execute.

It didn’t pass the parameter to the child pipeline. Is there something special that I need to do to send the parameter to the child?

Thanks,

Scott

pkk_1's avatar
pkk_1
New Contributor
6 years ago

Hi Scott,

In Pipeline execute’s Parameter Name you need to set the ID(can be any name) and in the Parameter Value enable the expression and access the ID that you want to read.

Do share the sample csv file.

Thanks,
Pooja

  • swright's avatar
    swright
    New Contributor III
    6 years ago

    Hi Pooja,

    Do I somehow use the sequence number from the sequence snap as an index for a json array generated from the csv?

    Thanks,

    Scott

    (Attachment sl_test.csv is missing)