JSON stands for JavaScript Object Notation and it is an Open and Standard format to read an object with attributes and values. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |