We will use ODBC PowerPack to connect and query a JSON file / URL. In this post, we will learn how to import REST API in MS Access (JSON or SOAP XML data).

11.7 Preview SOAP API Response / Generate SQL Code for SOAP API Call.

11.6 Create DSN using ZappySys XML Driver to call SOAP API.

11.5 Using SoapUI to test SOAP API call / Create Request Body XML.

11.4 Video Tutorial - Introduction to SOAP Web Service and SoapUI tool.

11.3 Example SQL Query for SOAP API call using ZappySys XML Driver.

11 Calling SOAP Web Service in MS Access.

10.0.5 Use -FAST Option to enable Stream Mode.

10.0.4 Consider using Metadata / Data Caching Option.

10.0.3 Consider using pre-generated Metadata / Cache File.10.0.2 Avoid Special features in SQL Query (e.g.10.0.1 Use Server-side filtering if possible in URL or Body Parameters.10 REST API / XML SOAP Performance Tips for MS Access.9 Other settings for REST API / SOAP XML Call in MS Access.8 REST API / SOAP Web Service Connection Settings for MS Access.7.3 Paginate by URL Path (Loop until no record).7.2 Paginate by URL Parameter (Loop until certain StatusCode).7 REST API / XML SOAP Pagination Settings for MS Access.5 How to import REST API data to Access.4 Configure ODBC DSN for ZappySys JSON Driver.

3 An introduction to Rest API and OData.

Import json into excel 2016