Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"