NationStates API (nationdata/regiondata)

[HMS Unicorn]

On the Nation Data Dump, could the <INFLUENCE> tag be altered to have an attribute containing the SPDR stat, a la <INFLUENCE spdr="23">?

I'd love to see SPDR included in the nation dump as well.

[Eluvatar]

Soft Power Disbursement Ranking and the Influence shard refer to different things: the SPDR census is a total of influence accumulations across any and all regions a nation has them in, while the Influence shard reflects the Influence level of the nation in the region as a word.

Would you be asking for the SPDR census to be included in the daily dumps or for the actual regional influence value behind the regional influence level and why or why not?

[HMS Unicorn]

Personally I'd like to see the SPDR census included. The reason for this is that I often have to process region-wide SPDR rankings in large regions (TNP, other GCRs, Europeia). Doing so currently requires a very large number of API calls to fetch all of the regional census=65 rankings and values. Having this information available in the nation dumps would make this process much easier and less bandwidth-intensive.

[Aurum Raider]

Soft Power Disbursement Ranking and the Influence shard refer to different things: the SPDR census is a total of influence accumulations across any and all regions a nation has them in, while the Influence shard reflects the Influence level of the nation in the region as a word.

Would you be asking for the SPDR census to be included in the daily dumps or for the actual regional influence value behind the regional influence level and why or why not?

SPDR, for the exact reason that HMS is asking for it. The actual regional influence would be nice, but unless I'm mistaken you can't get that from an API call to start with, and it's not what I was after anyway.

The only thing we can't get from the API that I might want is a region shard telling me when the region is going to update, but going out on a limb, I'd assume that isn't going to happen

[Eluvatar]

The only thing we can't get from the API that I might want is a region shard telling me when the region is going to update, but going out on a limb, I'd assume that isn't going to happen

Why not?

[Roavin]

The only thing we can't get from the API that I might want is a region shard telling me when the region is going to update, but going out on a limb, I'd assume that isn't going to happen

Why not?

omg thank you! If you can also add that to the dumps, I'll probably propose to you.

[Eluvatar]

Is there a good reason not to do it?

[Roavin]

Is there a good reason not to do it?

The only reason I can think of is that you don't want me to propose to you.

(well and filesize but the difference should be negligible)

[Aurum Raider]

Eluvatar, you cannot even comprehend how much I love you.

Do you think we can get the shard for nations?

[Altmoras]

Personally I'd like to see the SPDR census included. The reason for this is that I often have to process region-wide SPDR rankings in large regions (TNP, other GCRs, Europeia). Doing so currently requires a very large number of API calls to fetch all of the regional census=65 rankings and values. Having this information available in the nation dumps would make this process much easier and less bandwidth-intensive.

This would be quite useful for a thought I had as well, would be very nice to just be able to grab the number for a nation.

[Eluvatar]

I will add LASTUPDATE to the daily dumps.

[Roavin]

I will add LASTUPDATE to the daily dumps.

*gets on one knee.....*

[HMS Unicorn]

Can we have hope that the censusid=65 influence score will be added too? Given that that's what started this discussion .

[Eluvatar]

There's no way we will add all the censuses. That leaves the question of how do we add just one census.

I defer to [violet].

[Caelapes]

When will Z-Day data from last year (zombie action, survivors, dead, and number of zombies) reset on the API?

[Trotterdam]

When will Z-Day data from last year (zombie action, survivors, dead, and number of zombies) reset on the API?

I think moments before the new pandemic begins.

Speaking of which, thanks for reminding me to test my zombie tracker to make sure it still works. Turns out my crude parser needed some tweaking on where to expect newlines.

[Fauxia]

When will Z-Day data from last year (zombie action, survivors, dead, and number of zombies) reset on the API?

Well, N-Day reset 30 minutes before, so I might expect the same

[Mantenos]

Is there any way to limit the amount of API requests per minute on a google sheets document? I've got upwards of 200 shards I have to individually request but I can't do so without it importing all at once, locking me out for 15 minutes continuously. I could look into the daily dumps but that's a bit more manual work I was hoping to avoid.

[Eluvatar]

This happened due to my mistake.

[Mantenos]

This happened due to my mistake.

Could you elaborate?

[Eluvatar]

This happened due to my mistake.

Could you elaborate?

I made a small change and didn't check its correctness in the right way and accidentally uploaded it before I meant to.

Edit: and I just realized I posted in the wrong topic. My post should've been here: viewtopic.php?f=15&t=427116

[Mantenos]

Oh okay. My question still stands then.

[Eluvatar]

Is there any way to limit the amount of API requests per minute on a google sheets document? I've got upwards of 200 shards I have to individually request but I can't do so without it importing all at once, locking me out for 15 minutes continuously. I could look into the daily dumps but that's a bit more manual work I was hoping to avoid.

The way to rate limit google sheets, and indeed to split the results of one API request across multiple cells, is to write googlescript code. This and this other sheet may be useful as examples, and this post may be helpful at following the rules.

[Minoa]

While testing a census query (https://www.nationstates.net/cgi-bin/ap ... mode=score and https://www.nationstates.net/cgi-bin/ap ... p;scale=76), I noticed that Census ID 76 is returning a number in exponential form, but the "gdp" shard returns the full number correctly.

I wonder if the Census ID 76 shard can be shown as a full number like the "gdp" shard?

Also, I would like to see the ability to exclude certain shards while doing the "scale=all" query: for example, I type "scale=all-81-82-83-84" (literally "all scales except 81-84") to exclude the Zombie-related shards.

-- Minoa

[Eluvatar]

While testing a census query (https://www.nationstates.net/cgi-bin/ap ... mode=score and https://www.nationstates.net/cgi-bin/ap ... p;scale=76), I noticed that Census ID 76 is returning a number in exponential form, but the "gdp" shard returns the full number correctly.

I wonder if the Census ID 76 shard can be shown as a full number like the "gdp" shard?

Also, I would like to see the ability to exclude certain shards while doing the "scale=all" query: for example, I type "scale=all-81-82-83-84" (literally "all scales except 81-84") to exclude the Zombie-related shards.

-- Minoa

I think it would make sense for 'all' to mean 'all active' and ignore the shards that aren't being updated. I would like to confirm [violet] doesn't have any issue with such a change first however.

I have no thoughts on census 76.