R: Help with Consuming A REST Web Service Using SQL And POST from ITJungle

Hi Kevin

I tried to read the discussion in RPG400 ;

i tried :

1. to set DCL-S fieldname datatype CCSID(37) , but i receive error in compiling (i’m run V7r2 ) !!

2. I have tried with chgjob CCSID 1141 and when i run the pgm i don’t receive error but the WebService answer with “API_KEY wrong”, but the API_KEY is correct , i tried with Postman (with the same data)

3. I Have tried with chgjob CCSID 1144 (Italian CCSID) and now i receive error that says “An indicator variable is required”



Any suggestion ?

Thanks



Da: Kevin Bucknum [mailto:Kevin@xxxxxxxxxxxxxxxxxxx]
Inviato: martedì 3 marzo 2020 18:29
A: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: giovanni.arturi@xxxxxxxxx
Oggetto: Re: Help with Consuming A REST Web Service Using SQL And POST from ITJungle



You can't use the sql http functions with a job ccsid of 65535. https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzajq/rzajqhttpoverview.htm





There was a discussion this morning on the RPG400 list that discusses this same error.





On Tue, 2020-03-03 at 18:14 +0100, Giovanni Arturi via MIDRANGE-L wrote:

Hi all

I have found the example at

<https://www.itjungle.com/2017/10/02/guru-consuming-rest-web-service-using-sq>

https://www.itjungle.com/2017/10/02/guru-consuming-rest-web-service-using-sq




l-post/ and followed it. I have customized the example, but when i run the
program i receive in SqlCode the value "-332" and as message i receive
"Invalid character conversion between CCSID 65535 and CCSID 1200"

Where am i wrong ? mu job run under 65535 CCSID

Thanks in advance