Can JSON handler in Pipeline create multiple record ?

Question

I've a simple JSON file, I'm able to use JSON handler in pipeline but it only 1 creates 1 record which clubs all values it has iterated . Is it possible instead to create multiple records with 1 value each VALUE : {{b.raw_record["Sub"]}}
JSON SCHEMA IN PIPELINE
{
      "File": [
        "https://drive.google.com/file/d/198aaoChWTow6sI6UR6tjacVehkn42obz/view?usp=drivesdk"
      ]
    }
JSON

{
  "Sub": [
    {
      "File": [
        "https://drive.google.com/file/d/1qcp01CTNJTp1h49sHKvd5tNaWq7CZJ9a/view?usp=drivesdk"
      ]
    },
    {
      "File": [
        "https://drive.google.com/file/d/1CnpmMC-Em4cFr-4_sUCHCFVPqvdwKMcP/view?usp=drivesdk"
      ]
    }
  ],
  "sl": "Bhaiya"
}​

------------------------------Prashant Maheshwari------------------------------

RaziD · Answer

HI Prashant;I think you are missing JSON Records Path. I am not sure if you want it to create for each Sub or File or any thing else. JSON Records Path for each file will be something like:/Sub/0/FileIf the Sub is child of another one you need to add that in front:/SubParent/Sub/0/FileAlso, I think this is how you need to use values:{{b['raw_record']['Sub']}}I hope this helps.------------------------------Razi D.Desta Tech LLCrazi@destatechs.com------------------------------

Sign up

Login to the community