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.
Szymon's avatar
Szymon
New Contributor II
4 years ago

Puh! Apologies, that I have not described everything I had tried before posting.
Among others, I had tried parseFloat as well.

I wonder if you have tried it yourself, jolly good. Pipeline is attached
parseFloat($amount.toFixed(2)) will remove the decimal ‘.00’, so this brings nothing.
As a result you would get: 1000 → “1000.00” → 1000

Again I need to add decimals to 1000 to get 1000.00, NOT to “1000.00”

{
"amount" : 1000.00
}

anyone?
thank you.
toDouble_2022_01_12.slp (5.9 KB)

bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

Actually, It will not. I agree with @viktor_n on this one. This is a validation from the pipeline you attached:

Don’t rely on the preview within the snap, check the actual output after validation.

Regards,
Bojan

  • 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)