Hi community,
Could you please help me out on this?
I'm trying to import the table of OL 2024.
I failed to get the Parse JSON action work properly.
Do you have any suggestions? Thanks!
The response is XML, not JSON. Therefore the "Parse JSON" action can't parse it. Use the "Parse XML" action.
You can also use the "Import from Web API" action that automatically detects JSON or XML responses and parses them accordingly. It does importing and parsing in one action.
PS. It might also be a good idea to spend a few minutes and learn the difference between JSON and XML formats just for general knowledge.
Hi Dgudkov
I come with error on the "Parse XML" action.
And there is also error for the "Import from Web API" action.
Any idea how I could get them work? Thanks!
Oh, wait! I should've had my morning hot beverage.
It's not even XML. It's not even a web API response. It's just a web page. What you see is just an HTML page. Web (HTML) pages are not data objects. They are text documents. Retrieving structured data from a text document is not a trivial task. EasyMorph doesn't have a built-in action for that.
Try finding a public API that returns the data, or just download the table as a file from the internet (there are many sources).