You need to use the RESTClient object not HTTPClient object to directly retrieve data from a REST API into a DataWindow.  The REST API needs to return data in a supported JSON structure, in this case it MUST be a single-level JSON structure since you want to use the RetrieveOne function.  Otherwise, you will need to first parse out the JSON data, format it properly for your DataWindow, and then use the ImportJSON function to import it into your DataWindow.

Can only see the one line of code you posted, but I'm guessing that you actually did use the RestClient and maybe just typed HTTPClient in your post by mistake?  If you did use the RestClient and it's returning -4, that means it timed out.  There's a TimeOut property on the RestClient object that you can set to give it more time.  Are you able to get the service to work in a tool like SOAPUI or Postman?

KR

My mistake, I am using RestClient.  I don't know why I typed HTTPClient. 

Hi Craig;

   FYI: From the PB Help ....

Return value
Long

Returns values as follows. If any argument's value is null, the method returns null.

>=0 -- Returns the number of rows if it succeeds
-1 -- General error
-2 -- Invalid URL
-3 -- Cannot connect to the Internet
-4 -- Timed out
-7 -- Failed to decompress data
-10 -- The token is invalid or has expired
-15 -- Unsupported character sets

HTH

Regards ... Chris