Blue Prism 6.10 Utility HTTP request
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-08-21 02:44 PM
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.
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-08-21 03:19 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-08-21 05:07 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-08-21 06:52 PM
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-08-21 07:15 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-08-21 01:34 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-08-21 07:35 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-08-21 02:51 AM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-08-21 01:22 PM
------------------------------
Dhaval Panchal
Senior Data Researcher II
S&P Global
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-08-21 02:04 PM
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
------------------------------
