Can you parse through a CSV file and drop them individually to an FTP Destination
I have this source CSV file below:
InternalID,Dealer,PO,TrackingNumber,ShippingCost
31135499,CustomerName,ME14010822,994888592733,22.16
31165574,CustomerName,ME14010823,994894163305,43.13
31222468,CustomerName,ME14010824,994911414053,2.26
Is it possible to drop them individually to an FTP destination? Please and thank you!
0
Comments
and can we use the filename conventions below:
Raul,
Just to be clear is your use case that you are wanting to get the CSV from an FTP location and then for each line on the CSV create a single CSV file in a different FTP location/directory?
As for the file name conventions. Yes you you could use a handlebar function in the file name field in order to get the name as you need.
similar to this example. You may have to modify your formula a bit in order to get it the way you need.
file-{{timestamp "YYYYMMDD"}}-{{batch_of_records.0.record.PO}}.csv
Good morning Kelly Izer. Let me correct myself as I was disorganized yesterday. :)
My source tile is coming from a NetSuite Saved Search with the preview data below.
{"page_of_records": [
{
"record": {
"id": "31135499",
"Internal ID": "31135499",
"Document Number": "848410",
"DealerInternalID": "334",
"Dealer": "ACME Company",
"PO": "ME14010822",
"TrackingNumber": "334888592733",
"ShippingCost": "22.16"
}
},
{
"record": {
"id": "31165574",
"Internal ID": "31165574",
"Document Number": "849238",
"DealerInternalID": "334",
"Dealer": "ACME Company",
"PO": "ME14010823",
"TrackingNumber": "334894163305",
"ShippingCost": "43.13"
}
},
{
"record": {
"id": "31222468",
"Internal ID": "31222468",
"Document Number": "851050",
"DealerInternalID": "334",
"Dealer": "ACME Company",
"PO": "ME14010824",
"TrackingNumber": "334911414053",
"ShippingCost": "2.26"
}
}
]
}
When we send this to our destination FTP tile, It's saving it into one CSV file. Is it possible to save it into multiple CSV files, in this case 3 CSV files? I tried the option to "Skip Aggregation", to no avail.
Many thanks!
Good day! We resolved the issue by using the parameter on our source tile "How many records would you like to export?" and set it to 1. Then we will just run the flow every 15 mins.
We also used the handlebar expression for the filename to be "Shipment-{{timestamp "YYYYMMDD_hhmmss" "America/Chicago"}}-{{batch_of_records.0.record.PO}}.csv"
If you have a more efficient approach, let us know. Please and thank you!
Raul Bernales Set your page size to 1 on your NetSuite export
Please sign in to leave a comment.