Question

How to read structured data from an html-file

  • 23 June 2020
  • 1 reply
  • 67 views

Userlevel 1

Hello, We have a subscription to a service that delivers us (daily) some structured XML-data in a php-webfile. So we can go to this webpage and copy the data. We could do that every day, but need a lot of extra handling to get these data in Google Sheets or MailChimp for example. What application, platform, service or Zapier functionality could automatically read and process this xml-code from a certain webpage?. Here’s an example of this code:

<Export>
<ROWSET>
<ROW>
<volgnummer>1423892</volgnummer>
<datum>2020-06-22</datum>
<typevraag>informatieaanvraag</typevraag>
etc
</ROW>
<ROW>
<volgnummer>1423895</volgnummer>
<datum>2020-06-22</datum>

etc


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +8

Hi there @Angelo Spiler - Thanks for the question about XML-code. I’ve gone ahead and escalated your question to our Support team to better assist here. Please stay tuned!