ODBC guide

Read all records from a JSON OData service table


Gets all rows from the Customers entity set when the service is configured for JSON. Use the table name that matches your OData metadata (entity set name).

SELECT * FROM Customers