SQL Server - Import REST API / Read JSON / XML File / Call SOAP (Pagination, OAuth, OData)

[@pvksmaheeth8816]

you didnt talked about pagination in this video ? if i missed place the exact time in reply

[@deltaaccount6865]

Instead of using ZappySys do we have any opensource?

[@andreybolanos4883]

Hi, I am looking for an app/code that hopefully already exist. I need to drop this code into my server to import data files (XML, JSON, CSV, etc) automatically and according a specific schedule drop the data into a SQL data base. The code has to be scheduled and run automatically to upload aproximately 1000 files a day. Any ideas?

[@ZappysysSoft]

Hi Andrey, assuming you have written some code in Stored Proc which you can schedule via SQL Agent Job. We do support file upload via POST. Did you try below to upload file content to API ? If you still face issue contact ZappySys Support at zappysys.com/support (Support is FREE under 30 days trial) SELECT * FROM $ limit 3 WITH (METHOD='POST', HEADER='Content-Type: text/plain || x-hdr1: AAA' ,SRC='httpbin.org/post' ,BODY='@c:\files\dump.json' ,IsMultiPart='True' )

[@ZappysysSoft]

Here are some example queries you can use with this driver zappysys.com/onlinehelp/odbc-powerpack/scr/json-odbc-driver-sql-query-examples.htm zappysys.com/onlinehelp/odbc-powerpack/scr/xml-odbc-driver-sql-query-examples.htm zappysys.com/onlinehelp/odbc-powerpack/scr/csv-odbc-driver-sql-query-examples.htm

[@ZappysysSoft]

Check this article to learn more about loading REST API data into SQL Server zappysys.com/blog/import-rest-api-json-sql-server/