How to "GET" from an xml file?

Audrie Phoenixa · 07/20/21

My company is using a helpdesk/support ticket/eForm program to receive requests, and then manually entering those tasks into smartsheet. The program will allow me to POST the data via XML at the same time as form submission. I am trying to figure out how to automate this so that the data will then automatically be passed on to smartsheet in real time. (I'd like to avoid manually importing the xml file) This doesn't seem like it would be that difficult, but I'm having a hard time finding tutorials or documentation on how to get started. Can someone please point me in the right direction?

Genevieve P. · 07/22/21

Hi @Audrie Phoenixa

You can import sheets from a CSV or XLSX files using the Smartsheet API (see here), however this does not currently support importing from an XML file. (See this post in Stack Overflow).

Would the helpdesk you're using be able to connect using Zapier, or could you have the information exported as a different file type?

Cheers,

Genevieve

How to "GET" from an xml file?

Answers

Categories