SQL Anywhere 16.0.0.1915 We are developing a JSON payload to be passed via a web service to an IOS application. It is simple enough to use the FOR JSON AUTO clause and I have obtained a variety of JSON selects. But our iPad developers have asked for a combined payload that would concatenate several selects into a single long varchar. How to accomplish that escapes me. |
Thanks for the ideas, looks like I will just "string" the data together. (Glad JSON is rather simple in that regard.) The basic SELECT... FOR JSON is so easy, I was hoping for one more silver bullet: - SELECT * FROM A FOR JSON INTO ls_jsona; - SELECT * FROM B FOR JSON INTO ls_jsonb; - SELECT ls_jsona || ls_jsonb; OR: - SELECT * FROM A FOR JSON UNION ALL SELECT * FROM B FOR JSON; Guess I'll have to actually do some work :-). Thanks, Bill |
If you have create for example two JSON Strings in two variables.
You can combine these two JSON Objects in an array.
So instead of having different web service calls for different select statements you concatenate them in one variable and return the combine result as payload. HTH 1
Likewise you could create a JSON object instead of an array:
(15 Sep '16, 03:47)
Volker Barth
|
As JSON uses UTF-8 encoding by default, you might prefer a long nvarchar.