Reading XML from Internet

[irade92]

Hi
I am trying to collect data from a file from internet but not very successfull.


From my form I am sending this parameter "oz10763" and button "Find" should go to this address https://api.zdravstvo.gov.mk/rest/prescriptions/oz10763 and all I see is a structure of XML file. I need to read the data from this file and put them into my table.
Please help me.
Thanks a lot

[June7]

Access can import xml file.

You can save the xml to local file then import with the wizard or by opening the xml as an object in VBA and parsing each line as with a text file.

You might find this thread of interest https://www.accessforums.net/forms/a...her-34620.html

[irade92]

Thanks June 7. You are really master. The above code really helped me. With a little changing of the code I succeded to read the web page. Now I have to return what I have chosen from the data.
this code I have to Post

Post Request Example<?xml version="1.0" encoding="UTF-8"?><prescription><prescription_code>WE45927</prescription_code><exempt_from_participation>true</exempt_from_participation><pharmacist_facsimile>999999</pharmacist_facsimile><drug_fund_code>979376</drug_fund_code><quantity/></prescription>and the address where to post is: https://api.zdravstvo.gov.mk/rest/prescriptions/realize

[June7]

Sorry, if it's not in the referenced thread then outside my experience.

[orange]

I had a post that dealt with getting exchange rates from the internet. It may help.
See post 4 at
https://www.accessforums.net/queries...ery-28974.html