Interacting with a web service in RPG

I am trying to use HTTPGETCLOB to access a web service. I used
HTTPPOSTCLOB to successfully request a token from the service, unpack the
JSON return data, and store it in a DB2 table. The storing works I think,
as I do see a row created with a current timestamp and token.

In the documentation for the web service, the token is defined as a
"string". I have a feeling I am interacting with .NET but not 100%
positive.

I have tried storing the token as a CHAR(2000), VARCHAR(2000), and
CLOB(2000), using CCSID 37 and 1208. The job's CCSID is 37.

When I try to retrieve the token to send it using HTTPGETCLOB, I am
getting this message:


Message ID . . . . . . : CPF503E Severity . . . . . . . : 30
Message type . . . . . : Sender copy
Date sent . . . . . . : 01/22/21 Time sent . . . . . . : 09:53:14


Message . . . . : User-defined function error on member QSQPTABL.
Cause . . . . . : An error occurred while invoking user-defined function

HTTPGETCLOB in library SYSTOOLS. The error occurred while invoking the

associated external program or service program B2RESTUDF: in library
SYSTOOLS.D, program entry point or external name
com.ibm.db2.rest.DB2UDFWrapper.httpGetClob, specific name HTTPG00005.
The
error occurred on member QSQPTABL file QSQPTABL in library QSYS2. The
error
code is 1. The error codes and their meanings follow:
1 -- The external program or service program returned SQLSTATE 38000.
The
text message returned from the program is:
██SYSTOOLS.HTTPGETCLOB██HTTPG00005██Content is not allowed in prolog. .


When I test the API in SOAPUI, it does work and I do get a response. I am
using the token retrieved with HTTPPOSTCLOB by cutting and pasting the
token field from ACS SQL Script window into SOAPUI.

My feeling is that there is a CCSID mismatch somewhere. Has anyone else
experienced this? We're on V7R3 with pretty current PTFs.


Thank you,

Doug


"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments accompanying it) contain confidential information belonging to the sender. The information is intended only for the use of the intended recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of the information is strictly prohibited. Any unauthorized interception of this transmission is illegal under the law. If you have received this transmission in error, please promptly notify the sender by reply e-mail, and then destroy all copies of the transmission."