Import specific rows from Inbound Rest API file

[chandukollapart]

Hi,

We are using Rest API and saveResponseBodyAsAttachment to import file and attach to the data source as csv. We need to import 40 files daily. In the csv file we have rows that needs to import start from middle. Attached csv for example. We do have “device”, “system.deviceid” column and only those data need to import. Also once we imported that file next file needs to be imported.

Any suggestions on how to import from specific row and column? And to import all files one by one. Thank you

 

[Ankur Bawiskar]

@chandukollapart 

if you are sure the column header will always be row

no direct way to handle this.

you can parse the CSV and then handle the data import.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@chandukollapart 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.