Forum Discussion

deepak_shaw's avatar
deepak_shaw
Contributor
5 years ago

JSON parse error with string has new line characters

Noticed some times I received JSON parse error when the string contains new line characters.
pkk_1's avatar
pkk_1
New Contributor
6 years ago

Hi Scott,

You can separate out the logic and processing in different pipelines.
1] Pipeline 1 : Master/Parent pipeline that reads the csv file and extracts the records and pass ID as pipeline parameter to child Pipeline 2. If there are huge records, you can enable re use and configure the pool size as required.
2] Pipeline 2: To act on the ID received in the pipeline parameter and execute REST snap

Thank you

  • swright's avatar
    swright
    New Contributor III
    6 years ago

    Hi Pooja,

    I tried that with File Reader > CSV Parser > Sequence > Mapper > Pipeline Execute.

    It didn’t pass the parameter to the child pipeline. Is there something special that I need to do to send the parameter to the child?

    Thanks,

    Scott

    • pkk_1's avatar
      pkk_1
      New Contributor
      6 years ago

      Hi Scott,

      In Pipeline execute’s Parameter Name you need to set the ID(can be any name) and in the Parameter Value enable the expression and access the ID that you want to read.

      Do share the sample csv file.

      Thanks,
      Pooja

      • swright's avatar
        swright
        New Contributor III
        6 years ago

        Hi Pooja,

        Do I somehow use the sequence number from the sequence snap as an index for a json array generated from the csv?

        Thanks,

        Scott

        (Attachment sl_test.csv is missing)