Skip to main content
Question

How to read structured data from an html-file

  • June 23, 2020
  • 1 reply
  • 79 views

Angelo Spiler

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

steph.n
Forum|alt.badge.img+8
  • Builder
  • June 26, 2020

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!