Using Excel To Link To Web Data From FFXIAH

Language: JP EN DE FR
New Items
2023-11-19
users online
Forum » FFXIAH.com » Help » using Excel to link to web data from FFXIAH
using Excel to link to web data from FFXIAH
Offline
Posts: 23
By benitez 2018-07-31 15:57:39
Link | Quote | Reply
 
Hi all,

Trying to get an excel file to automagically update a list of prices for AH items from my server. I share this with my LS mates to help plan out Ambuscade and Login Point usage and turning them into gil.

The issue I run into is that whenever I go and open an item - say a stack of Alexandrite - https://www.ffxiah.com/item/2488/alexandrite/?stack=1
it defaults back to the asura server - Has anyone successfully set up FFXIAH as a data source into an excel file?
 Ragnarok.Casey
Offline
Server: Ragnarok
Game: FFXI
user: Casey
Posts: 160
By Ragnarok.Casey 2018-08-07 17:22:57
Link | Quote | Reply
 
Looks like that information is supplied via cookie -- the "sid" key. No idea if excel can do that for you.
[+]
necroskull Necro Bump Detected! [82 days between previous and next post]
Offline
Posts: 10
By Pechvarry 2018-10-28 13:16:13
Link | Quote | Reply
 
I've been looking into this. I can use xpath to pull in the URL but I'm learning as I'm going... anyone happen to know if there's a way to like... post a cookie value as part of a URL?
necroskull Necro Bump Detected! [1294 days between previous and next post]
 Carbuncle.Briga
Offline
Server: Carbuncle
Game: FFXI
user: Modron
Posts: 4
By Carbuncle.Briga 2022-05-14 04:06:24
Link | Quote | Reply
 
Bump necro thread, but i was going through this and thought i could contribute:
https://www.ffxiah.com/item/2488/alexandrite/?sid=28
Alex prices in asura

https://www.ffxiah.com/item/2488/alexandrite/?sid=6
Alex prices in carbuncle

use url as data sources for power query in excel and log in anonymous

Cheers
Briga
Log in to post.