Adding Bloomberg API to Alteryx Workflow

[karandave]

Hi,

How can i connect a Bloomberg API to a Alteryx workflow to find some details for specific data point within excel.

[BrandonB]

Hi @karandave 

There isn't an official Bloomberg connector, however Bloomberg does have an API available.  It may be easiest to use an R or Python package with the R or Python tools to do so with something like Rblpapi: https://cran.r-project.org/web/packages/Rblpapi/Rblpapi.pdf. You could have the script query the data and then pull into the workflow. 

Technically you could also use regular workflow tools in conjunction with the download tool by looking at the documentation here: https://www.bloomberg.com/professional/support/api-library/ along with my write up on how to connect to APIs here: https://community.alteryx.com/t5/Engine-Works/APIs-for-Beginners-Integrate-All-the-Systems/ba-p/8074.... This approach may require you to figure out a few more things on your own in digging through the API documentation for Bloomberg. 

There was also an company called Labrosenblatt who made a connector a while back, but it would appear that their page is no longer live: https://www.linkedin.com/pulse/30-minutes-seconds-our-new-alteryx-bloomberg-elevate-your-scott/. You could try reaching out on LinkedIn to see what happened there and if it is still available. 

Alternatively, if you have the Excel workbook already set up, you could use a quick VBA script to refresh the data prior to workflow run using a technique like you can see here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Run-Command-Executing-Excel... 

I hope this helps!