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...
  • jcornelius's avatar
    jcornelius
    4 years ago

    From the error you posted, the Map data snap is looking for $ID but $ID does not exist in the document stream, check your input doc values

doug_fossler's avatar
doug_fossler
New Contributor
8 years ago
Copy LinkReport

punchInDate is in “yyyy-MM-dd”
punchInTime is in “HH:mm”

punchIn should be something like “MM/dd/yyyy HH:mm”, or “yyyy-MM-dd HH:mm”, or “MMddyyyyHHmm”, etc.

Supratim's avatar
Supratim
Contributor III
8 years ago
Copy LinkReport

@doug.fossler
Use this-
$punchInDate.toLocaleDateString(‘{“format”:“yyyy-MM-dd HH:mm”}’

if punchInDate is coming as date field , if it’s coming as String then 1st do Date.parse($punchInDate), then use formater in mapper snap

  • abjoe's avatar
    abjoe
    New Contributor II
    8 years ago
    Copy LinkReport

    Thank You so much. It helped. 🙂