| Pages: [1] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Jim Augus
Hard Knocks Inc.
6
   |
Posted - 2013.02.20 17:02:00 -
[1] - Quote
Morning everyone, have a couple questions relating to the importXML function within google docs as I am having a bit of issues.
First off what is the access level that the API key needs in order to work in google docs to pull corp assets? (All the boxes checked? Narrowed to a specific character on the account?) The director API i am working with has only the corp information boxes checked (assets, wallet, jobs ect...) and is narrowed to the director charaecter on the account.
I have been able to pull personal assets easily using the following ImportXML function, with my personal non director level API.
=ImportXML("https://api.eveonline.com/char/AssetList.xml.aspx?vcode=XXX&keyID=XXX", "sum(//row[@locationid=60003760 and @typeid=601 ]/@quantity)")
This would tell me without issue for testing purposes the number of Ibis's I had located in Jita 4-4.
So taking that I assumed I could in turn use this same function to pull corp asset data. by slightly changing it to the following.
=ImportXML("https://api.eveonline.com/corp/AssetList.xml.aspx?vcode=XXX&keyID=XXX", "sum(//row[@locationid=XXX and @typeid=16275 ]/@quantity)")
I was hoping to use the above to test and see if the API pull could give me for instance how much stront we have in our system (using the locationid of our system). The above function gives an error of "The data could not be retrieved, please check the URL"
To take this a step further I was hoping to be able to single out a specific corp hangar array (CHA) anchored in space, I have noticed that CHA's have unique itemid's that remain static until the item is repackaged. So I am hoping to create an xpath query that will narrow by CHA and give me a specific quantity of an item in said CHA.
There is a considerable amount of corp assets does this bog down the pull and in turn create an error in google doc's in the importXML function? Are the permissions correct for my director API? I can pop the following into a browser and get the raw XML data of our corp assets without a problem using the API.
https://api.eveonline.com/corp/AssetList.xml.aspx?vcode=XXX&keyID=XXX
So I feel like if the API can pull the data the permissions on the API shouldn't be a problem. I think my problem lies with my xpath query.
Have been trying to figure this out for awhile, willing to toss some isk someones way if they help me figure this one out.
Thanks in advance! |
Jim Augus
Hard Knocks Inc.
6
|
Posted - 2013.02.22 19:11:00 -
[2] - Quote
A friendly bump to see if anyone might have any insight, I am still unable to get this to function.
Leaning towards google docs not liking to sift through so much raw xml data. Can anyone confirm? |
Jim Augus
Hard Knocks Inc.
6
|
Posted - 2013.02.26 16:40:00 -
[3] - Quote
I think what might be restricting me is some type of timeout or limit within google docs.
When I input my importXml function it begins loading, takes around 10 seconds then errors to a problem with the URL. I am thinking since this is a corp asset database with a considerable amount of information is google docs just timing out or unable to process the information?
If this is the case is the only way to do this via a script that trims down the xml data? |
Elmore Jones
Orange Street
Redrum Fleet
13
|
Posted - 2013.02.26 17:06:00 -
[4] - Quote
Not what your asking about I know, but a definite limitation to your idea - GoogleDocs are limited to 50 xml imports per sheet. I hit this limit on some of my manufacturing sheets.
+++ Reality Error 404 - Reboot Cosmos +++ |
Jim Augus
Hard Knocks Inc.
6
|
Posted - 2013.02.26 17:46:00 -
[5] - Quote
Yeah :( I know, you can get around this by using concat (). If you google that youll see a tutorial of how it can help you easily surpass the limit. |
Influenca Pandemik
Anubis Logistics and Services
3
|
Posted - 2013.04.04 12:50:00 -
[6] - Quote
this works for me:
ImportXML(Settings!$D$3; "sum(//row[@typeid="&B9&" and @locationid=60002569]/@quantity)")
Only major difference I see is me using a ";" between the API URL and the xpath and you using a ",".
Regards,
IP
|
|
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |