I built an interface to a SOAP service some years ago and found the 'suds' library (https://github.com/suds-community/suds) quite functional for unpicking what was coming through. I also saw no need to write out to CSV and back - just built up a cellset from the input and use write_values to update (though I did have a debug option which wrote a CSV file....)
------------------------------
David Usherwood
------------------------------
Original Message:
Sent: Tue July 23, 2024 04:31 AM
From: Edward Stuart
Subject: Workday and Planning Analytics
I have used a series of Python executable scripts to export SOAP data to CSV for loading into TM1
SOAP uses XML which can be difficult to navigate and to translate into TM1 readable formats, I found the ElementTree XML API very useful and a browser extension called "Wizdler" for reading the WSDL queries
Happy to answer any SOAP questions you might have and on a separate note plus the Workday documentation on that link is very good
------------------------------
Edward Stuart
Original Message:
Sent: Mon July 22, 2024 11:06 AM
From: Desi French
Subject: Workday and Planning Analytics
Hello, just following up with if anyone have actually done this with Python\TM1PY or another method.
------------------------------
Desi French
Original Message:
Sent: Mon April 13, 2020 03:09 PM
From: David Usherwood
Subject: Workday and Planning Analytics
Workday has a SOAP API https://community.workday.com/sites/default/files/file-hosting/productionapi/index.html
TM1 does not natively support this, but you could look at using Python and TM1PY to join the dots.
------------------------------
David Usherwood
Original Message:
Sent: Thu April 09, 2020 10:20 AM
From: Vikas Bhatia
Subject: Workday and Planning Analytics
Hi Paul,
Workday data would be connecting to a relational source. PA should be able to connect to receive and send data.
Vikas
------------------------------
Vikas Bhatia
Original Message:
Sent: Thu April 09, 2020 09:15 AM
From: paul YOUNG
Subject: Workday and Planning Analytics
Thanks for the response!
I suspected that Workday would like have to be flat files.
------------------------------
paul YOUNG
Original Message:
Sent: Wed April 08, 2020 07:22 PM
From: paul YOUNG
Subject: Workday and Planning Analytics
Hi all,
Has anyone done any integration between Workday and Planning Analytics?
------------------------------
paul YOUNG
------------------------------
#PlanningAnalyticswithWatson