These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Out of Pod Experience

 
  • Topic is locked indefinitely.
 

LibreOffice WEBSERVICE function issue
Author
Previous Topic Next Topic
Kerono Thalmor
Ghost Bear Covenant
#1 - 2015-10-26 18:03:58 UTC
Hi, I'm not sure I'm posting this in the right section, I was gonna post it in the tech section or the general discussion but this isn't directly related to EVE so... Yeah.

I've made a spreadsheet for my EVE industry things, it gets market prices from eve-central's API (hence the non-direct relation to EVE). I made it in Excel, on Windows. Today, however, I moved EVE to Linux and I wanted to take my spreadsheet with me. I've had LibreOffice for a while, and today I tried pulling my spreadsheet into it. I ran into a bit of a snag, however, in that I can no longer pull API data from the web. The formula I use for Tritanium, for instance, is as follows:

=SUM((FILTERXML(WEBSERVICE(CONCATENATE($Math.$B$3,(VLOOKUP($A$2,$TypeID.$B:$C,2,0)),$Math.$C$3)),"//sell/min")))


This results in the cell displaying #VALUE and I cannot for the life of me find out what's going wrong here. Can anyone give me some pointers?

█░█░███░███░█░█

███░░█░░██░░█░█

█░█░░█░░█░░░███
RoAnnon
Republic University
Minmatar Republic
#2 - 2015-10-27 01:29:11 UTC
The wormhole corp I was previously in had a buyback program that used a spreadsheet on Google Docs with the same API pull from Eve-Central to generate the baseline jita price that the corp paid from. Without migrating the spreadsheet at all, those API pull codes no longer work. It seems to me that a change in the API itself is to blame for breaking the functionalaity.

So, you're a bounty hunter. No, that ain't it at all. Then what are you? I'm a bounty hunter.

Broadcast4Reps

Eve Vegas 2015 Pub Crawl Group 9

Houston EVE Meet
Kerono Thalmor
Ghost Bear Covenant
#3 - 2015-10-27 20:28:29 UTC  |  Edited by: Kerono Thalmor
RoAnnon wrote:
The wormhole corp I was previously in had a buyback program that used a spreadsheet on Google Docs with the same API pull from Eve-Central to generate the baseline jita price that the corp paid from. Without migrating the spreadsheet at all, those API pull codes no longer work. It seems to me that a change in the API itself is to blame for breaking the functionalaity.


I've actually had a similar problem with Google Docs, and I found that it's a problem with Google Docs itself, not the API, since it works flawlessly in Excel.

EDIT: I figured it out. The new formula is as follows:

=FILTERXML(WEBSERVICE(CONCATENATE(Math.$B$3,(VLOOKUP(MinCalc.$A2,TypeID.$B:$C,2,0)),Math.$C$3)),"number(//sell/min)")


It turns out that the SUM function was mucking with things. It seems it can only accept cell ranges and numbers directly in the formula. What needed to change was the FILTERXML function needed to convert the data from //sell/min to a number so that it displayed correctly, pulled the data, and so it was in a form that the rest of the spreadsheet could use.

█░█░███░███░█░█

███░░█░░██░░█░█

█░█░░█░░█░░░███