Parsing PHP / Javascript table

[JS3000]

Hi guys,

I have some experience with parsing tables, but I run into trouble with this specific table (that feeds from a German official authority but only outputs in PDF): Umsatzsteuer-Umrechnungskurse 2022 (smart-rechner.de)

I made a little script but I got not further in parsing it... Probably you guys have some easy script to parse it out (and for myself to get some further experience)?

[IraWatt]

Hey @JS3000, 

If your just looking for the exchange rates the page uses this URL to get USD rates: https://cdn.jsdelivr.net/gh/prebid/currency-file@1/latest.json?date=20220704 

[JS3000]

Thanks for this link, how did you get it? I did not see it via Inspect Element.

[IraWatt]

@JS3000 I had a check of the network tab to see what information was being pulled externally:

Also had a look in the JS files:

[JS3000]

Thanks! That table comes quite in handy, I'm specifically looking for the EUR > USD conversion, but the table you provided doesn't match the table in the site:

So perhaps they're quering another database?

[IraWatt]

Hey @JS3000,

The data in the table is just static. Here is a workflow to get the data: