[Ftpapi] HTTP Headers in REST GET

["Danforth, Ken" <kdanforth@xxxxxxxxxx>]

I’m currently using HTTPGETCLOB to consume a webservice and receive JSON data.  I’d like to try accessing the same webservice using the HTTP_string() function in LIBHTTP.  The SQL statement for HTTPGETCLOB looks like this:

 

SELECT * FROM                                             

    Json_Table(SYSTOOLS.HTTPGETCLOB('https://qa.teamwilberforce.com/public/api/consignments/21973599',

  '<httpHeader>

  <header name="accept" value="application/vnd.public.api.v1+json" />

  <header name="content-type" value="application/json" />

  <header name="authorization" value="Basic ***obscured***" />

</httpHeader>')

,'lax $'

    Columns(id int PATH  'lax $.id'

      , created_at varchar(40) PATH 'lax $.created_at'

      , updated_at varchar(40) PATH 'lax $.updated_at'

      , Site_Code varchar(10) PATH 'lax $.site_code'

      , Reference varchar(10) PATH 'lax $.reference'

      , custom_reference varchar(20) PATH 'lax $.custom_reference'

      , custom_label_printer varchar(40) PATH 'lax $.custom_label_printer'

      , special_instructions varchar(100) PATH 'lax $.special_instructions'

      , despatch_date date PATH 'lax $.despatch_date'

      , account_payable varchar(40) PATH 'lax $.account_payable'

      , charge_account varchar(40) PATH 'lax $.charge_account'

      , carrier_service varchar(40) PATH 'lax $.carrier_service'

      , service_type varchar(40) PATH 'lax $.service_type'

      , pickup_at varchar(40) PATH 'lax $.pickup_at'

      , deliver_by varchar(40) PATH 'lax $.deliver_by'

      , deliver_at varchar(40) PATH 'lax $.deliver_at'

      , return_type varchar(40) PATH 'lax $.return_type'

      , consignment_number varchar(40) PATH 'lax $.consignment_number'

      , estimated_delivery_date varchar(40) PATH 'lax $.estimated_delivery_date'

      , actual_delivery_date varchar(40) PATH 'lax $.actual_delivery_date'

      , carrier_name varchar(40) PATH 'lax $.carrier_name'

      , service_name varchar(40) PATH 'lax $.service_name'

      , service_code varchar(40) PATH 'lax $.service_code'

      , service_rate Decimal(10,2) PATH 'lax $.service_rate'

      , service_rate_excl_gst Decimal(10,2) PATH 'lax $.service_rate_excl_gst'

      , poa_carrier char(10) PATH 'lax $.poa_carrier'

      , cheapest_carrier_service varchar(40) PATH 'lax $.cheapest_carrier_service'

      , cheapest_carrier_rate decimal(10,2) PATH 'lax $.cheapest_carrier_rate'

      , cheapest_carrier_rate_excl_gst decimal(10,2) PATH 'lax $.cheapest_carrier_rate_excl_gst'

      , manifest_id int PATH 'lax $.manifest_id'

      , carrier_selection_by varchar(40) PATH 'lax $.carrier_selection_by'

      , despatched_at varchar(40) PATH 'lax $.despatched_at'

      , despatch_by varchar(40) PATH 'lax $.despatch_by'

      , state varchar(20) PATH 'lax $.state'

      , url varchar(100) PATH 'lax $.url'

      , public_tracking_url varchar(100) PATH 'lax $.public_tracking_url'

      , has_quote_origin varchar(10) PATH 'lax $.has_quote_origin'

      , has_tickets varchar(10) PATH 'lax $.has_tickets'

      , NESTED '$.items[*]'

         columns(reference_Number varchar(20) PATH '$.reference'

               ,ssccs varchar(30) PATH '$.ssccs')

   )       

  ) AS MyTable

;

 

I can’t seem to get the call to HTTP_string correct.  Always getting back “HTTP/1.1 404 Not Found”.  I suspect I’m not sender the HTTP header correctly.  I’ve tried putting it in the URL parameter and in the REQUEST parameter, but neither has worked.  Not worried about the JSON response.  Will use YAGL to parse it.

 

Can anyone tell me how to format the HTTP_string to work the same as the above HTTPGETCLOB?  Any help is appreciated.  Thanks.

 

Ken

***************************************************************** *************************************************************************************************************** Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message. ****************************************************************** *************************************************************************************************************

-- 
_______________________________________________
Ftpapi mailing list
Ftpapi@xxxxxxxxxxxxxxxxxxxxxx
http://scottklement.com/mailman/listinfo/ftpapi