API for BLS Occupational Employment and Wage Estimates

I have been looking at the BLS series IDs for Occupational Employment and Wage Estimates, and while I can identify the series iDs I want I cannot figure out how to pull them with Alteryx. My guess is that I need a URL?

Has anyone successfully pulled this data?

Accepted answers

CharlieS

Hi @RUSA

An API isn't necessary since the Alteryx Download tool can download the text from these BLS publications::

https://download.bls.gov/pub/time.series/ce/

Using these URLs, you can use the Download tool to grab the text and parse the data as necessary. Check out the attached example where I download and parse the series lookup table.

20200310-DownloadBLSText.yxmd

All comments

CharlieS

Hi @RUSA

An API isn't necessary since the Alteryx Download tool can download the text from these BLS publications::

https://download.bls.gov/pub/time.series/ce/

Using these URLs, you can use the Download tool to grab the text and parse the data as necessary. Check out the attached example where I download and parse the series lookup table.

20200310-DownloadBLSText.yxmd

RUSA

Thank you, Charlie. That is very helpful!

Regressionman

Hi Charlie,

I'm new to Alteryx and am looking to download a specific series from BLS (LNS14000000). I ran your sample workflow and saved the output to a db table. Works great! However, I'm not understanding how to use Alteryx to download a series (versus a series listing).

What am I not understanding?

Thanks,

Gary

severhart

Just me jumping in over 2 years later to say THANK YOU Charlie - this has helped enable me to download the data from JOLTS for BLS data reporting. So thankful!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335