Forum Discussion

manohar's avatar
manohar
Contributor
7 months ago
Solved

records to json file

Hi there, I am pulling data from Coupa to store it in json files. its coming in below format. I need to create a JSON file for each record and store it into sftp server with id as file name.  input...
  • mramaswamy's avatar
    mramaswamy
    3 years ago

    Thanks for your reply. My root element was wrong. I was able to get this work by changing it.

    Thanks,
    Murugan

GjorgeArgirov's avatar
GjorgeArgirov
New Contributor
6 months ago

Simpler Alternative
If you only need the document ID as the filename, you can set the Binary Header property in the JSON Formatter snap to the ID field.

I’ve attached a sample pipeline that shows the settings in action.

Hope it helps—let me know if any part isn’t clear!