Re: How to eliminate escape characters from JSON in IWS REST API?

Never mind. I'm just going to have the stored procedure run a SQL cursor, so the IWS REST API transforms the results to JSON correctly.

A while back I got slightly better performance by using JSON functions to select directly into a stored procedure INOUT parameter (as opposed to using a SQL cursor). I was trying to have my IWS REST API procedure call a stored procedure that used JSON functions to directly select into an INOUT parameter. It gave me the escape characters in the JSON string.

My project can deal with the performance of an IWS REST API procedure that calls a stored procedure using a SQL cursor. So I'm cutting my losses and going with the SQL cursor approach.

Thanks,

Kelly Cookson
Senior Software Engineer II
Dot Foods, Inc.
1-217-773-4486  ext. 12676
www.dotfoods.com<http://www.dotfoods.com>

From: Kelly Cookson
Sent: Sunday, March 7, 2021 2:42 PM
To: Web Enabling the IBM i (AS/400 and iSeries) <[email protected]>
Subject: How to eliminate escape characters from JSON in IWS REST API?

How do I get rid of escape characters in JSON output when calling a stored procedure from an IWS REST API?

-- 
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/web400.