How to automate import XML process within serviceNow

[Amrutha7]

Hi,

Every Monday, my team manually imports XML data into the ServiceNow table. I need to automate this process. Can anyone assist with this?

[Diogo Ramos]

What do you want to automate, the data fetching or the data import itself ? 

I have an similar situation where I have a catalog item for which users manually add an attachment, which is then submitted and within flow designer I just put the attachment in a data source and run an on time import. But there are many different ways of achieving the same result.

On my use case it really needs to be a user dropping an excel file and therefore a manual process, but if you can automate the part where you need to get the xml, then you just run a flow designer with a rest call that gets data in xml format and then runs it through an import set. Or just ask the other party to call your import/table API.

Cheers

[AndersBGS]

Hi @Amrutha7 ,

In general if you could make a scheduled export of the data and send by mail, then you could do a automated data import. But again, you need to investigate the possibility for auto fetch/receive the data at first. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards 

Anders