cancel
Showing results for 
Search instead for 
Did you mean: 

Blue Prism 6.10 Utility HTTP request

DhavalPanchal
Level 4
Hi,

I was using 6.2 version and in that I use Utility HTTP request to call API. I use below configuration and it is working fine.
23512.png
I migrated to 6.10 in that above configuration not give me result. I see blank collection from API.

I build this for companies house API.

------------------------------
Dhaval Panchal
Senior Data Researcher II
S&P Global
------------------------------
29 REPLIES 29

ewilson
Staff
Staff
Hi @DhavalPanchal,

​Can you provide some details about the make up of your Header collection? When you say you're seeing a blank collection from the API, what does that means? Which collection are you referring to? The action itself returns 2 strings (Result and Headers as JSON) and a number (Status Code).

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

In headed I provide Authentication: ############.
This is result (as data item) in 6.10 ({"start_index":0,"items_per_page":25,"items":[],"filing_history_status":"filing-history-available","total_count":0})

while I run same in 6.2 I get this type of detailed result as data item ({"items_per_page":25,"filing_history_status":"filing-history-available","start_index":0,"items":[{"description":"miscellaneous","type":"MISC","date":"2019-04-12","category":"miscellaneous","description_values":{"description":"Confirmation of transfer of assets and liabilities"},"links":{"self":"/company/01378853/filing-history/MzIzMTk0ODM0N2FkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/Wki1Yf-Akcj6eFeYAT6apTm2LFvL2AfSFse0pTMIh3s"},"paper_filed":true,"pages":1,"barcode":"R838C37K","transaction_id":"MzIzMTk0ODM0N2FkaXF6a2N4"},{"links":{"self":"/company/01378853/filing-history/MzIzMTk0ODA4OGFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/zyyWVsHFbCja_AuG00ckXjuJ1TdeAD8IO1cIRbJQPUk"},"description_values":{"description":"Notification from overseas registry of completion of merger"},"paper_filed":true,"description":"miscellaneous","date":"2019-04-12","type":"MISC","category":"miscellaneous","pages":1,"barcode":"R81MT5OW","transaction_id":"MzIzMTk0ODA4OGFkaXF6a2N4"},{"type":"TM01","category":"officers","description":"termination-director-company-with-name-termination-date","date":"2019-01-07","links":{"self":"/company/01378853/filing-history/MzIyMzg1MzE5M2FkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/DR73UOIeUkOyUxYxKvxiE5-oHY29YAzCCq1sLDX8048"},"description_values":{"officer_name":"Jonathan Wyn Parry","termination_date":"2018-12-31"},"subcategory":"termination","action_date":"2018-12-31","pages":1,"barcode":"X7WMDI9L","transaction_id":"MzIyMzg1MzE5M2FkaXF6a2N4"},{"subcategory":"termination","action_date":"2018-12-31","description_values":{"termination_date":"2018-12-31","officer_name":"Wai-Fong Au"},"links":{"self":"/company/01378853/filing-history/MzIyMzg1MzIyMmFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/5ZTYhZnl1chdepPOQtyhP7_PYba2cT4eWuJjatDQHtQ"},"date":"2019-01-07","description":"termination-director-company-with-name-termination-date","type":"TM01","category":"officers","pages":1,"barcode":"X7WMDI7L","transaction_id":"MzIyMzg1MzIyMmFkaXF6a2N4"},{"category":"officers","type":"TM01","description":"termination-director-company-with-name-termination-date","date":"2019-01-07","links":{"self":"/company/01378853/filing-history/MzIyMzg1MzIyMGFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/iDrjVEtP74gn444gfH4WLxzXKYO5_RabOAtEX2-cDEM"},"description_values":{"officer_name":"Stuart William Sinclair","termination_date":"2018-12-31"},"action_date":"2018-12-31","subcategory":"termination","pages":1,"barcode":"X7WMDI5D","transaction_id":"MzIyMzg1MzIyMGFkaXF6a2N4"},{"date":"2018-09-19","description_values":{"description":"CB01 - cross border merger notice"},"description":"miscellaneous","type":"MISC","paper_filed":true,"category":"miscellaneous","links":{"self":"/company/01378853/filing-history/MzIxNDg2NjM1N2FkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/m5rkmHXiMTMhLfAjAs21uFD5GEF6Gd0jeU87JJBnHiI"},"pages":42,"barcode":"L7EI4K88","transaction_id":"MzIxNDg2NjM1N2FkaXF6a2N4"},{"action_date":"2018-06-29","category":"confirmation-statement","date":"2018-07-09","description_values":{"made_up_date":"2018-06-29"},"description":"confirmation-statement-with-no-updates","links":{"self":"/company/01378853/filing-history/MzIwOTM0MDgxNmFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/Svricwk_YSlOVTJDX_fkSoCJusW5tdpAK8CN3NxwCEM"},"type":"CS01","pages":3,"barcode":"X79UFZJE","transaction_id":"MzIwOTM0MDgxNmFkaXF6a2N4"},{"links":{"self":"/company/01378853/filing-history/MzIwNDIxMjk2M2FkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/jUAoan4GG4QrxG0QclPafpsKcxMJwj4Vy6GJJBU4TQc"},"subcategory":"change","description_values":{"officer_name":"Mr Malcolm Graham Mccaig","change_date":"2018-04-27"},"category":"officers","type":"CH01","action_date":"2018-04-27","date":"2018-05-03","description":"change-person-director-company-with-change-date","pages":2,"barcode":"X75526E4","transaction_id":"MzIwNDIxMjk2M2FkaXF6a2N4"},{"links":{"self":"/company/01378853/filing-history/MzIwNDIxMjg3M2FkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/2f0yegTYfXez_m8Eqt4Flu-b2mRAa1pAXewPsFGM8_E"},"subcategory":"change","category":"officers","description_values":{"officer_name":"Mr Malcolm Graham Mccaig","change_date":"2018-04-27"},"action_date":"2018-04-27","type":"CH01","description":"change-person-director-company-with-change-date","date":"2018-05-03","pages":2,"barcode":"X75524CQ","transaction_id":"MzIwNDIxMjg3M2FkaXF6a2N4"},{"description_values":{"made_up_date":"2017-12-31"},"description":"accounts-with-accounts-type-full","type":"AA","category":"accounts","paper_filed":true,"date":"2018-03-21","links":{"self":"/company/01378853/filing-history/MzIwMDU5NzU2MWFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/5g9PRXeGodZVXM4S8PIBOG3SaXzBs3NJ51RSoyN27S4"},"action_date":"2017-12-31","pages":49,"barcode":"A71WZ402","transaction_id":"MzIwMDU5NzU2MWFkaXF6a2N4"},{"action_date":"2016-12-31","description_values":{"made_up_date":"2016-12-31"},"type":"AA","description":"accounts-with-accounts-type-full","links":{"self":"/company/01378853/filing-history/MzE4MzA5MzI0NmFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/cBqsOXKnJnCjXBO3AU5CzYbp5ikAL1J8ee_leqDIpw4"},"paper_filed":true,"category":"accounts","date":"2017-08-17","pages":46,"barcode":"A6CIR156","transaction_id":"MzE4MzA5MzI0NmFkaXF6a2N4"},{"description":"confirmation-statement-with-updates","type":"CS01","description_values":{"made_up_date":"2017-06-29"},"links":{"self":"/company/01378853/filing-history/MzE4MDQwMzM1M2FkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/dDwU58yB_2m7jEiKoWmOMI8MfXzz8duraO_jx3Rztbk"},"category":"confirmation-statement","action_date":"2017-06-29","date":"2017-07-12","pages":4,"barcode":"X6AJFSAX","transaction_id":"MzE4MDQwMzM1M2FkaXF6a2N4"},{"description":"notification-of-a-person-with-significant-control","type":"PSC02","description_values":{"psc_name":"Qbe Holdings (Eo) Limited","notification_date":"2016-04-06"},"subcategory":"notifications","links":{"self":"/company/01378853/filing-history/MzE4MDM5NzQyMGFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/qOavj1kdudV9n-i1MP1H6jQHGa_73VVDVViwhvcVNfE"},"category":"persons-with-significant-control","action_date":"2016-04-06","date":"2017-07-12","pages":2,"barcode":"X6AJ7ZVE","transaction_id":"MzE4MDM5NzQyMGFkaXF6a2N4"},{"action_date":"2017-06-26","links":{"self":"/company/01378853/filing-history/MzE3OTI5ODI1NGFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/qpdAvOv2OTzTo3oU7fXInywMISfHTPHJ9F9-7MXsZJY"},"type":"AP03","subcategory":"appointments","date":"2017-06-29","category":"officers","description_values":{"appointment_date":"2017-06-26","officer_name":"Alexandra Jane Smith"},"description":"appoint-person-secretary-company-with-name-date","pages":2,"barcode":"X69L03JC","transaction_id":"MzE3OTI5ODI1NGFkaXF6a2N4"},{"links":{"self":"/company/01378853/filing-history/MzE3OTI5NjExMWFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/dQqazz7kz52JJt5U8RmjbTMEMf6UYiwA4XdOeC2Onw4"},"type":"TM02","action_date":"2017-06-26","date":"2017-06-29","subcategory":"termination","category":"officers","description_values":{"termination_date":"2017-06-26","officer_name":"Esther Felton Smith"},"description":"termination-secretary-company-with-name-termination-date","pages":1,"barcode":"X69KXE6Y","transaction_id":"MzE3OTI5NjExMWFkaXF6a2N4"},{"subcategory":"appointments","description_values":{"officer_name":"Mr Nigel Joseph Douty Terry","appointment_date":"2016-12-19"},"date":"2016-12-23","description":"appoint-person-director-company-with-name-date","category":"officers","type":"AP01","action_date":"2016-12-19","links":{"self":"/company/01378853/filing-history/MzE2NTE1NTA5MGFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/gXtpVjxf_DpwujTR3saghgZSfa_u7Y02tbppf7FE8RM"},"pages":2,"barcode":"X5MDJTNM","transaction_id":"MzE2NTE1NTA5MGFkaXF6a2N4"},{"date":"2016-12-22","description_values":{"officer_name":"Philip Andrew Dodridge","termination_date":"2016-12-19"},"description":"termination-director-company-with-name-termination-date","subcategory":"termination","action_date":"2016-12-19","type":"TM01","links":{"self":"/company/01378853/filing-history/MzE2NTE1NTA3MGFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/CIeBJd-D4nT9T3fS1-sdZQzuNVFLKAB3Pn-QadRBp_4"},"category":"officers","pages":1,"barcode":"X5MDJTOA","transaction_id":"MzE2NTE1NTA3MGFkaXF6a2N4"},{"links":{"self":"/company/01378853/filing-history/MzE1OTA3NDQwNWFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/jnv7spePfcU9AQeKd3-uD9DRVcIxKOtg71rt2_969MA"},"date":"2016-10-06","description":"change-person-director-company-with-change-date","category":"officers","description_values":{"change_date":"2016-07-19","officer_name":"Mr Malcolm Graham Mccaig"},"subcategory":"change","type":"CH01","action_date":"2016-07-19","pages":2,"barcode":"X5H1MDJ6","transaction_id":"MzE1OTA3NDQwNWFkaXF6a2N4"},{"associated_filings":[{"action_date":1468195200000,"category":"capital","date":"2016-07-11","description":"statement-of-capital","description_values":{"capital":[{"currency":"GBP","figure":"20,082,852"}],"date":"2016-07-11"},"type":"SH01"}],"type":"AR01","links":{"self":"/company/01378853/filing-history/MzE1MjY1NjQwMWFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/HKDP56btbCgV2awXAIon8f7aeH5veEGcxiwyiT73yVI"},"date":"2016-07-11","description":"annual-return-company-with-made-up-date-full-list-shareholders","action_date":"2016-06-29","description_values":{"made_up_date":"2016-06-29"},"category":"annual-return","pages":8,"barcode":"X5B07I1K","transaction_id":"MzE1MjY1NjQwMWFkaXF6a2N4"},{"category":"accounts","description_values":{"made_up_date":"2015-12-31"},"paper_filed":true,"type":"AA","action_date":"2015-12-31","date":"2016-05-11","description":"accounts-with-accounts-type-full","links":{"self":"/company/01378853/filing-history/MzE0ODIxNDkyMGFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/9LzU83Y6TTcJpmEzJmNRh9CjQps2-bcpOQJxl0ta7JQ"},"pages":45,"barcode":"A56FHZ2Z","transaction_id":"MzE0ODIxNDkyMGFkaXF6a2N4"},{"description_values":{"made_up_date":"2015-06-30"},"date":"2015-07-22","action_date":"2015-06-30","links":{"self":"/company/01378853/filing-history/MzEyNzU0MDIyMmFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/4Gm6iPnibvE4Cfa81T-mjN51gM1fiG_ATATsAnRSd10"},"type":"AR01","category":"annual-return","description":"annual-return-company-with-made-up-date-full-list-shareholders","associated_filings":[{"action_date":1437523200000,"category":"capital","date":"2015-07-22","description":"statement-of-capital","description_values":{"capital":[{"currency":"GBP","figure":"20,082,852"}],"date":"2015-07-22"},"type":"SH01"}],"pages":9,"barcode":"X4C6QDE4","transaction_id":"MzEyNzU0MDIyMmFkaXF6a2N4"},{"action_date":"2015-06-29","links":{"self":"/company/01378853/filing-history/MzEyNjk2NTQxOWFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/tX7lVubuRpw6rzDQP08F1bsmDh6hPQ7MUbd3oAm1yQ8"},"description":"termination-director-company-with-name-termination-date","date":"2015-07-13","category":"officers","subcategory":"termination","type":"TM01","description_values":{"officer_name":"Joe Gordon","termination_date":"2015-06-29"},"pages":1,"barcode":"X4BJA83N","transaction_id":"MzEyNjk2NTQxOWFkaXF6a2N4"},{"action_date":"2015-06-29","links":{"self":"/company/01378853/filing-history/MzEyNjk2NTQyMmFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/XkVyROZavlG2jJlgtD_YMRXU1zfVNut9ZDcHxLEzK4Q"},"description":"termination-director-company-with-name-termination-date","date":"2015-07-13","category":"officers","type":"TM01","subcategory":"termination","description_values":{"termination_date":"2015-06-29","officer_name":"Dominic John Clayden"},"pages":1,"barcode":"X4BJA87U","transaction_id":"MzEyNjk2NTQyMmFkaXF6a2N4"},{"date":"2015-07-13","description":"termination-director-company-with-name-termination-date","action_date":"2015-06-29","links":{"self":"/company/01378853/filing-history/MzEyNjk2NTQxOGFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/f04G1Pw7xhVJ7yyttIRjhLL07sL5kHcobPKGyM5SKUI"},"subcategory":"termination","type":"TM01","description_values":{"officer_name":"Ian David Beckerson","termination_date":"2015-06-29"},"category":"officers","pages":1,"barcode":"X4BJA7XK","transaction_id":"MzEyNjk2NTQxOGFkaXF6a2N4"},{"description_values":{"officer_name":"Jan Leflot","termination_date":"2015-06-29"},"subcategory":"termination","type":"TM01","category":"officers","date":"2015-07-13","description":"termination-director-company-with-name-termination-date","links":{"self":"/company/01378853/filing-history/MzEyNjk2NTQxNWFkaXF6a2N4","document_metadata":"https://frontend-doc-api.company-information.service.gov.uk/document/znYarw9dMQWTezUn1MvEgnuWcpbBmCsQZGjVK9hmpcw"},"action_date":"2015-06-29","pages":1,"barcode":"X4BJA89E","transaction_id":"MzEyNjk2NTQxNWFkaXF6a2N4"}],"total_count":281})

​I store API result in data item and then convert that JASON to collection. but in 6.10 there is no record collection shows blank.

------------------------------
Dhaval Panchal
Senior Data Researcher II
S&P Global
------------------------------

Ok, so one thing I see right off is that you're setting your Accept request header to Application/pdf, but the result data is JSON. If you expect to receive JSON you should be setting Accept to application/json. The fact that you're getting back some JSON shows that the request is actually making it to the server. I would verify the authentication credential you're passing in to be sure it's the same between your 6.2 and 6.10 environments. Even a single white-space character at the end or beginning of the auth info can cause it to fail in which case could cause your server to not respond with the data you expect.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

I changed it json but still not working.  For some company I get correct output but its very rare. so I guess no issue for authentication. Is there any major change in HTTP request between 6.2 and 6.10?  Chrome version also updated for 6.10.

for few case get the result then why I am not getting for all cases like 6.2?

Please let me know any further details require.

------------------------------
Dhaval Panchal
Senior Data Researcher II
S&P Global
------------------------------

I don't have a copy of the v6.2 VBO, so I can't compare/contrast. However, you have both so you can see what's in the code stage of both VBOs on the HTTP Request action. I'm guessing there are some changes, but I'm highly skeptical of anything in the VBO causing the issue you're seeing when you telling me sometimes things work fine. Sometimes they don't.

Going back to the auth header. Have you actually titled the header Authentication or is it Authorization? The HTTP basic auth header should be Authorization (ex. Authorization: Basic [Base64 encoded username:password]).

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

Hi Wilson,
its authorization, it was my mistake. I attached file of both code comparison. is there any browser setting require for api access.

------------------------------
Dhaval Panchal
Senior Data Researcher II
S&P Global
------------------------------

@DhavalPanchal,

It looks like there was a small bug in the handling of Authorization headers when you pass one in as part of the Headers collection. There is a parameter on the VBO called Force Pre Authorization that was designed to be used with the Username and Password parameters to handle HTTP Basic Authorization. In other words, the expectation was that you would set that Flag to True and populate the Username and Password values. Then we build the Authorization header for you, in the code.

We've uploaded a update to the HTTP VBO to the Digital Exchange. I'd suggest downloading the latest copy and see how that works for you.

In the revised version, priority is given to use of the Force Pre Authorization flag, followed by the Use Bearer Token flag (this is another option for the Authorization header), and finally any Authorization header included in the input Headers collection. To be clear, a web server will only look at the very first Authorization header it receives. All others should be ignored. So my recommendation is that you use the Force Pre Authorization flag in conjunction with the Username and Password parameters. If that's not possible, then you can stick with passing in your header within the Headers collection.

Cheers,


------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

What is username and password for Force Pre Authorization.

------------------------------
Dhaval Panchal
Senior Data Researcher II
S&P Global
------------------------------

Hmm. Let's go back to the beginning a bit. You said you were passing in a header called Authorization within the Headers collection. Did you create the value of that header, or did you just pull it from somewhere? Do you know if the service you're invoking is HTTP Basic auth or Bearer auth?

In an HTTP Basic auth situation the value of the Authorization header is a string made up of the word Basic and the Base64 encoded output of whatever username and password you server expects (concatenated together with a : (colon).

Here's an example of the value of the Authorization header in an HTTP Basic scenario with username jdoe and password 123pass:

Basic amRvZToxMjNwYXNz

Now, if the server you're connecting to is expects Bearer token authorization, the value of your header would be the word Bearer combined with the token string (bearer tokens are not Base64 encoded typically). Here's an example with a token value of RsT5OjbzRn430zqMLgV3Ia.

Bearer RsT5OjbzRn430zqMLgV3Ia

Cheers,


------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------