REST GET returns XML rather than JSON to store in the target sheet.

David Scott Stokes

unread,

Oct 21, 2013, 7:03:47 AM10/21/13

to excel-r...@googlegroups.com

Hi,
I am extracting data from a password protected site using GET to fetch data. This site returns XML rather than JSON. How do I adjust the cDataSet query for the XML being stored in the target sheet?
Regards
David

Bruce Mcpherson

unread,

Oct 21, 2013, 4:18:42 PM10/21/13

to excel-ramblings@googlegroups com

David..i don't have an xml digester. Excel has built in support for xml so i didn't bother..Bruce

--
You received this message because you are subscribed to the Google Groups "Excel Liberation" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excel-ramblin...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

David Scott Stokes

unread,

Oct 21, 2013, 5:07:03 PM10/21/13

to excel-r...@googlegroups.com

Hi Bruce,

That is a pity. I was looking at automating the following process:

(1) Download the key field from a site using cDataSet returning the XML with erSingleQuery

(2) Populate several sheets with data using the key field and erQueryPerRow

(3) Assemble certain data fields with suitable titles with VBA

(4) Post the result using JSON in to other applications.

cDataSet looks exceptionally well suited to this task with both erSingleQuery and erQueryPerRow. Also becase JSON is required in step 4. However, cDataSet is a masterpiece and so I am reluctant to break it open and tinker. I would far prefer to center the code around cDataSet as the key process enabler with an ongoing maintenance path. Buts needs must.

Thank you for your prompt reply.

Regards

David SCOTT STOKES
Chartered Accountant FCA PMP
david.sco...@inman.com.au www.inman.com.au
+61 417 531107 in Australia and global roaming

--
You received this message because you are subscribed to a topic in the Google Groups "Excel Liberation" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-ramblings/5bPrYqPTuVE/unsubscribe.
To unsubscribe from this group and all of its topics, send an email to excel-ramblin...@googlegroups.com.

Bruce Mcpherson

unread,

Oct 21, 2013, 6:44:21 PM10/21/13

to excel-r...@googlegroups.com

david - conversion of xml to json is fairly trivial.. i'll put it on my list and see if i can get to it. Im travelling on business right now

bruce

David Scott Stokes

unread,

Oct 22, 2013, 1:50:28 AM10/22/13

to excel-ramblings

Thank you Bruce. Safe travels.

Bruce Mcpherson

unread,

Oct 30, 2013, 2:18:30 PM10/30/13

to excel-r...@googlegroups.com

http://excelramblings.blogspot.co.uk/2013/10/xml-and-json-conversion-in-vba.html

rest-excel library can now deal with XML

David Scott Stokes

unread,

Oct 31, 2013, 2:11:14 AM10/31/13

to excel-ramblings

Thank you Bruce. :-)

Regards

David SCOTT STOKES
Chartered Accountant FCA PMP
david.sco...@inman.com.au www.inman.com.au
+61 417 531107 in Australia and global roaming

Reply all

Reply to author

Forward