topic Re: Failing to connect to odata in Connectivity & Data Prep

Failing to connect to odata

JediBabe — Wed, 15 Dec 2021 18:43:54 GMT

Hi,

We are trying to set up an odata connection to a mendix service. However I can't get the connector to work. Even using the test connection:

http://services.odata.org/V3/Northwind/Northwind.svc/

gives me the error:

"The service is unavailable"

Has anyone come across this before? This is our first attempt to use odata, so we haven't used this connector before. I have been clicking on "Web file" as there wasn't a box for odata - is this correct?

Re: Failing to connect to odata

chrisbrain — Fri, 06 Mar 2020 15:54:45 GMT

Hi,

I just tested this entering:

OData Service Root: https://services.odata.org/Northwind/Northwind.svc/

OData Resource Path: Employees

Accept: application/atom+xml

Into the GetData table and got 9 rows of data back.

You can see the other resources to enter for the 'OData Resource Path:' by running the ListResources table with:

OData Service Root: https://services.odata.org/Northwind/Northwind.svc/

Accept: application/xml