Forum Discussion

virender_prajap's avatar
virender_prajap
New Contributor III
7 years ago

How to split the string on the basis of length of bytes

How can i Split string( UTF-8) on the basis of bytes length and not on the basis of character counts. e.g String > 4000 bytes then split the string into multiple columns each not more than 4000 byt...
peter's avatar
peter
New Contributor III
6 years ago
Copy LinkReport

I am nearly there with my pipeline however I now have “nested” JSON, that is the first set of JSON returned by the API and the variables. Is there a way to flaten so that I have a single level of JSON?

I now have:
{
“number”:“RITM123456”,
“etc:123”,
variables : {
“Auto ID : 123”
“Autoversion ID : 345”
“Autoname : SQL stuff”
}
}

And I would like

{
“number”:“RITM123456”,
“etc:123”,
“Auto ID : 123”
“Autoversion ID : 345”
“Autoname : SQL stuff”
}
}

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    4 years ago
    Copy LinkReport

    @Pretty

    With the SnapLogic List Snap, you can list all tasks from the given project.

    Then, using a downstream SnapLogic Read Snap, you can read each task separately(by providing the path of each Task):

    That will returns you details about each task.

    Regards,
    Spiro Taleski