Dear All master Outsystems,
I saved the LOG I assigned with JSONSerialize to Database. how to split this on screen?
Thank
Hello Hothorasman,
To process the JSON object you can:
1. Create the necessary structure(s) for the JSON object you have saved in the database.2. Use JSONDeserialize in your flow2. Loop through the JSON Data list to process each object and append it to a local list variable.
I have attached a sample OML for a Traditional Web app for your understanding. If you are working on a Reactive app, the logic will still be very similar. When you run the application, click on 'OK' to view the parsed data from a JSON string that is the input for the JSON Deserialize action.
Hope this helps
AJ
Dear AJ ,
thanks for solution, i will try this
Greetings,
This might not be the right thread for this question, wondering if anyone could help me with the following.
I have the exact same log assignment logic as above and the input text is similar to the first post, however I'm facing the following string truncation error only when the input length is > 2000.
String or binary data would be truncated.The statement has been terminated.
Any suggestions of how to resolve this would be much appreciated.
Thank you.
Hi @Dota krabus ,
Typically this error "String or binary data would be truncated" will occur, if we have less length in database table attribute.
Example: Name column- Text datatype - with 150 length. But If you try to insert more than 150char length this error will occur.
Solution: Increase column length to 500 or whatever you want.