Discussions

 View Only
  • 1.  Can JSON handler in Pipeline create multiple record ?

    Posted 07-29-2022 16:14
    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
    ------------------------------


  • 2.  RE: Can JSON handler in Pipeline create multiple record ?

    Posted 08-04-2022 08:50
    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
    ------------------------------



  • 3.  RE: Can JSON handler in Pipeline create multiple record ?

    Posted 08-04-2022 22:33
    Thank you Razi . I was indeed missing JSON Records Path

    Below solved my problem !

    /Sub

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