Forum Discussion

PrashantMaheshw's avatar
PrashantMaheshw
Qrew Assistant Captain
2 years ago

Can JSON handler in Pipeline create multiple record ?

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
------------------------------
Pipelines

2 Replies

Sort By
  • RaziD_'s avatar
    RaziD_
    Qrew Cadet
    2 years ago
    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/File

    If the Sub is child of another one you need to add that in front:

    /SubParent/Sub/0/File

    Also, I think this is how you need to use values:

    {{b['raw_record']['Sub']}}

    I hope this helps.

    ------------------------------
    Razi D.
    Desta Tech LLC
    razi@destatechs.com
    ------------------------------
    • PrashantMaheshw's avatar
      PrashantMaheshw
      Qrew Assistant Captain
      2 years ago
      Thank you Razi . I was indeed missing JSON Records Path

      Below solved my problem !

      /Sub

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