Dear Community,
I'm looking for a slick solution how I can convert a Table Input into an XML String which I can use in a Python Script.
I created a very simple setup.
With a very simple Python code:
# List all non-standard packages to be imported by your
# script here (only missing packages will be installed)
from ayx import Alteryx
#Package.installPackages(['pandas','numpy'])
input_param = Alteryx.read("#1")
print (input_param)In my Example the Table Select and the Python print Result look like this.
Key
0 123456
1 341579
I need to convert the Table Data into an XML Format. The resulting format would look like this which I need to build into a SOAP WebService Body called by Python:
<SR_KEY>
<item>123456</item>
<item>341579</item>
</SR_KEY>
What options do I have?
- Doing everything in Python: How can I address and work with table data, I would need to loop all rows and address fields?
- Using Alteryx Objects: Which XML conversion or String Modification functions would you recommend?
