Help with api to excel?
 

Hi everyone

I’m hoping one of you guys can assist. I’m not a programmer but kind of
know what I want to do. In short I want to run an api into erepublik.com
and save the data in an excel spreadsheet.

The api is this one.....

api.erepublik.com/v1/feed/exchange/RUB/RON/feed

and the 10 returned records in xml looks like this...

<?xml version="1.0" encoding="UTF-8"?
<records type="array"
<record
<offer
<nameA Citizen</value
<value type="decimal"2.0</value
<for type="decimal"65.0</for
</offer
<seller
<is-a-company type="boolean"false</is-a-company
<urlhttp://www.erepublik.com/en/citizen/profile/499671</url
<is-a-citizen type="integer"499671</is-a-citizen
<is-an-organization type="boolean"false</is-an-organization
</seller
</record
</records

(See P17 http://api.erepublik.com/eapi-docs.pdf )

Has anyone any good ideas?
Thanks
DEC.


--
dec3
------------------------------------------------------------------------
dec3's Profile: 1398
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=171027

Microsoft Office Help