Access data sources via OData Endpoint or API Endpoint

[Page0727]

How would I go about gaining access to the following data source via Odata:

https://data.healthcare.gov/api/odata/v4/wb6u-x2ny or
https://data.healthcare.gov/OData.svc/wb6u-x2ny

There is also an option for an API End point:

https://data.healthcare.gov/resource/wb6u-x2ny.json

In applications like Tableau I can just point directly to it and voila I have my data, but I am not seeing any clear info on this kind of thing.

Thanks

[Kathrin]

Hi @Page0727,

you can access the JSON table via the API Endpoint using the Get Request node in KNIME Analytics Platform.

Afterwards you can transform the JSON into a table using the JSON Path and Ungroup node. This workflow shows you a little example based on the wb6u-x2ny.json table.

Forum_Question_Access_JSON_Table_Via_Get_Request – kathrin

Best
Kathrin

[Page0727]

This is great Kathrin exactly what I was after. Thanks!