OData: Message OData[0100] "contents ... not available"

ETL+ error message “OData[0100] - The contents of table xyz are not available for this use.
The remote server returned an error (403) Forbidden.”

Error Messages

  • OData[0100] - The contents of table xyz are not available for this use.

  • The remote server returned an error (403) Forbidden.

  • “You do not have access to this entity set.”

Copy/paste the OData URL on a browser

Resolution

  1. Examine the OData URL in a web browser.

  2. In ETL+, verify that the URL is correct in the Odata connection (ETL+ Source Object panel).

  3. That the user has the correct roles to pull the proper data: https://dataself.atlassian.net/wiki/spaces/DS/pages/67829767

  4. For OData v3, that the OData checkbox has been selected for the GI’s.