BookmarkSubscribeRSS Feed
gspila
Calcite | Level 5

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.

2 REPLIES 2
error_prone
Barite | Level 11
As a starter: which SAS version are you using?
gspila
Calcite | Level 5

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.

hackathon24-white-horiz.png

Join the 2025 SAS Hackathon!

Calling all data scientists and open-source enthusiasts! Want to solve real problems that impact your company or the world? Register to hack by August 31st!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1615 views
  • 0 likes
  • 2 in conversation