Forum Discussion

Garrett's avatar
Garrett
New Contributor II
5 years ago

SQL Insert from JSON change type and only type

Hi All, I have a Pipeline that takes data from a Rest API and converts it to a SQL database. This is all working and we are able to create the table without having to define the Schema in a mapper...
viktor_n's avatar
viktor_n
Contributor II
3 years ago
Copy Link

Hi @SL12345,

In the sample expression that I was writing, I was working on the sample with input as a string. Below is the sample that I was using.

[
    {
        "content": "1;2566;28.3.2023;28.3.2023;10;10;15;11;1,2,3,4,5,6,7,8,9,10;Eur;Euro;USD\n2;2567;28.3.2023;28.3.2023;10;10;15;11;1,2,3,4,5,6,7;Eur;Euro;USD\n3;2566;28.3.2023;28.3.2023;10;10;15;11;1,2,3,4,5,6,7,8,9,10;Eur;Euro;USD"
    }
]

For the expression to work, is expected the ‘content’ field on the input of the mapper with the CSV data inside as a string.

Regards,
Viktor N.

  • ptaylor's avatar
    ptaylor
    Employee
    6 years ago
    Copy Link

    Thank you for the kind words.

    If I understand what you’re asking, try using Include Paths in the JSON Splitter, or check “Include scalar parents” to get everything.