API connection with SAS

gspila — Tue, 06 Nov 2018 15:45:14 GMT

Hi everyone, I'd like to use API to connect to our new CRM which is based on an open source platform named ODOO.
The ODOO documentation explain how to connect with Python, Ruby, Php and JAVA, using a protocol called XML RPC.
I tried the connection with python, and it's very simple, but since I'm pretty new to python, and all of my ETL procedures are written in SAS right now, I would like to know if I can use SAS to make the API connection in both reading and writing.
I search for some documentation, but I couldn't find something that explain if it's possibile to connect to the database through API with SAS.

I hope I was clear enough, I'm sorry, but I'm pretty new in web service and API stuff, so maybe I'm missing something.

Re: API connection with SAS

error_prone — Tue, 06 Nov 2018 16:19:32 GMT

As a starter: which SAS version are you using?

Re: API connection with SAS

gspila — Wed, 07 Nov 2018 08:42:00 GMT

Sorry, forgot to mention, I have sas 9.4 ts1m3
I also requested the update to M5 because I read that the JSON engine was introducted, but I didn't received notification for the update.

topic Re: API connection with SAS in SAS Programming

API connection with SAS

Re: API connection with SAS

Re: API connection with SAS