Noob alert, how to formart something like this?

shiva · 2024-09-07T15:39:14.894+00:00

{"line1":"16 Boundary Stone Lane","line2":null,"city":"Widnes","postal_code":"WA8 3AJ","country":"UK","type":"billing","addressee"}

shiva
1 year ago
{"line1":"16 Boundary Stone Lane","line2":null,"city":"Widnes","postal_code":"WA8 3AJ","country":"UK","type":"billing","addressee"}
Andreas Møller
1 year ago
That’s and object is the formula editor, if you want it as text then you can use the “encode json” formula
shiva
1 year ago
looks even worse
Andreas Møller
1 year ago
Ah. Ok you have the json string 🙂

You can decode the json string first, then encode it with 2 indent
Alternatively you can just decode it and use the json viewer package
shiva
1 year ago
how to decode htough?/
Tom Ireland
1 year ago
Hey, shiva. Not sure what you mean. The JSON format in the description is what you have coming back from the API, so you shouldn't need to encode it. What are you trying to do for the 'Address:' field?
shiva
1 year ago
just wanna show the address there buddy
but thats how I am getting it from the database
Tom Ireland
1 year ago
Ah, okay. It wasn't immediately obvious. I wasn't sure if you wanted to format something as JSON, which is how the post reads, or format JSON as something else. If you take away the Encode JSON for a moment, what does the result display (as a screenshot and expanded)? It should show an object with key/value pairs.
Tom Ireland
1 year ago
As a note for future issues, when you ask "how to format something like this?", it's also helpful to include how you want to format it. Saves going down rabbit holes because of misinterpretation. 😉
💪1