Public Stats API

Sounds like you're not logged in and haven't specified a preferred default color.
Mine looks like this.

That's basically my take on it. It's a more organized, up to date wiki. Or the same as having a very large guild you can ask and get immediate answers about. But not everyone has that large guild, or the private wiki that updates immediately. So this evens that playing field a bit. :/

As for the whole "Exploration vs look it up" argument, that goes for almost every guide on the forums. And I love exploration as a game mechanic. I was annoyed when recipes were client side and you could deduce them before a patch went live. I liked the pitched idea of hidden recipes. However, that cat is out of the bag. The only way i've found to balance it in my mind is to go "People who want to discover, will discover. People who want to look it up, will look it up. Why force each side to play the way the other wants?"

 

What I'd eventually like to build is a tool that lets people scan for items for sale, get a history of prices on that item, and a map on where they could buy it now and how much it's listed at.

It just seems like an oversight to me from a data management perspective that we're being given all this data - with coordinates - and the coordinates are meaningless without a table and series of calculations that inform the data consumer the scene rotation, anchor point, etc. It's the equivalent of letting each country come up with their own latitude and longitude system. Sure, we could create a digital map if every country provided their reference point and coordinate system, but it's much more useful and user friendly to have a standard system. Another pro to a standardized system: a designer creating a new scene or altering a current scene won't break anything already created or require additional data translations. I work with data all day, every work day, and this type of translation or calculation on the data extraction side is fraught with issues. In theory, don't you have those items (scene rotation, anchor point) stored in a data element somewhere?

 

Well, part of the problem is the towns are kinda like the TARDIS, they're bigger on the inside. Because of that, you can't necessarily map them to a universal coordinate system. That doesn't mean they shouldn't be consistant, but even that ship has already sailed. At this point fixing it would be a pretty low priority, so we get to work with what we are given.

 

Is there a place where the items in the API are listed in one big long page? I'd like to match my spreadsheets up with Ports conventions, so for instance,

Iron Ore, generic ID for all Iron Ore, Database Name for same

Or: How do we find out what things are called?

 

Ok. No contracts signed or whatnot, but I'm glad it's at least on the list somewhere. Not putting it at least on the consideration list is equivalent to my ETL developers telling me they aren't bothering with decode tables or some such; if I have to look up every code in my table in the application screen and manually add the entry to a spreadsheet or google sheet to build a decode, the usefulness of the data element is questionable. (And yes, they did this once to me.)

If someone has done this, @Umuri @Jakub White , would you be willing to share the translation method and data?

 

Maybe it's about time to host it properly (and enabling POST) as well as maybe looking into some of the analyzers and mappings, so we can utilize some proper ES clients against it.

We have great experiences running managed ES off AWS but that of course isn't completely free.

 

I am trying to do a get at this url

http://shroudoftheavatar.com:9200/_...otGenerated&_source=Archetype&size=500&pretty

I am not seeing the Archetype in my response, is my request correct or is the API not returning Archetype currently?

Example of response below:

"_index": "logstash-2017.11.21",
"_type": "logs",
"_id": "AV_dEp12n7c6aq0AxfVk",
"_score": 3.0314434,
"_source": {}

 

Figured out my own answer , I was looking for LocationEvent:ItemGained_Loot. That LocationEvent is not listed on the GitHub documentation. Is there a current/correct list of all LocationEvent's in use?

 

There is a pulldown menu with many listed. Not sure if it includes all of them.

You can also run wildcard queries which will reveal all the permutations of the thing you are looking for.

 

I'm wondering, what is the EventType (or method) to see data when a player adds an item to a Player Vendor?

 

Unless things have changed, we don't get stats on player vendors.

 

But... But... That's probably one of the most important data points!

 

I just started playing with this tonight. This is so fun and easy to use! (Im just querying ES directly via Postman). I just incidentally stumbled upon my own death from testing the limits of Safe Fall the other day:

Code:

            {
                "_index": "logstash-2017.12.02",
                "_type": "logs",
                "_id": "AWAZV4W2n7c6aq0ADV8u",
                "_score": 14.065832,
                "_source": {
                    "ypos": "37.17",
                    "zpos": "372.21",
                    "xpos": "-153.50",
                    "@timestamp": "2017-12-02T22:27:34.000Z",
                    "SceneName": "Novia_R6_City_StormsReach",
                    "PlayerName": "Black Tortoise",
                    "LocationEvent": "PlayerDeath",
                    "timestamp": "%{month} %{day} %{hour}:00:00"
                }
            }

 

What's the best way to break up requests to make sure we get the data we want without going over the limits?

Will player vendor data be in the API before March?

Thanks

 

[ Copied from the Developer+ Tech Forum, for more visibility ]

I'm working on using the data available through the Sota API. I had a few questions though:

1) In regards to LocationEvent, what are the differences between:
ItemGained_ExplodeItem_Merchant (assuming Merchant Buys from Player, and the item is zero priced and is destroyed)
ItemGained_Crafting (assuming Player Gains from Crafting)
ItemGained_Merchant (assuming Player Buys from Merchant?)
ItemDestroyed_Crafting (assuming Player Destroys while Crafting)
ItemDestroyed_Merchant (assuming Merchant Destroys Item after buying from Player?)
ItemDestroyed_User (assuming Player Uses or Throws Away Item)

2) In the Source for an item, there are a few fields for price and quantity: GoldValue, EconomyGoldDelta and Quantity. My assumption, from looking in some sample pulls, to find out the true value of an item...you divide GoldValue by Quantity to determine the real price per item. Is that the gold value that a vendor buys the item from the player? Or is that the price an NPC vendor sells the item to a player? I've noticed the GoldValue on many items are in no way reflected in how the NPC Merchant sells or buys it.

3) Is there a way to more easily translate the ArcheType in to the actual item it represents? Some of the ArcheTypes don't have a clear path to the actual item it is, like Equipable_Archetypes/Armor/ArchetypeArmor_Chain_002_Feet... which item is that?
As it stands, I'm thinking the way through this is to have some sort of mapping table to translate the ArcheType to the actual item; but that would require manual mapping from one to the other.

4) Are there any plans to include Player Vendor pricing in the data collection? Something like LocationEvent: ItemGained_PlayerMerchant ?

Many Thanks!

 

How do you figure? Each transaction is not tracked by individual player vendors; just the prices. With a broad base of transactions, one can calculate the minimum, maximum and median prices...as well as calculate the cost ranges of crafting any particular item. It's not like you're getting a road map to Player Vendor X with the lowest price on an item (Agreed, that would be too much).