New to Salesforce Connect, but not necessarily new to parsing JSON responses and utilizing webservices.
I am attempting a test connection to https://jsonplaceholder.typicode.com/comments with Salesforce Connect.
When utilizing ODATA 2.0 or 4.0 with type set to JSON and no authentication set, I receive the following error after clicking Validate and Sync:
This data isn't available because the associated table in the external data source can't be found. Contact your administrator for help. Attempted query URL: https://jsonplaceholder.typicode.com/comments/$metadata
When utilizing Simple Url I receive the following error after clicking Validate and Sync:
Simpleurl type external data sources do not support authentication
Why is Salesforce Connect auto-appending the $metadata to the call?
How do I need to configure Salesforce Connect to utilize an endpoint like this so that is translates into external objects?