Public "API" for Naval Action

Taralin Snow · August 4, 2017

I've found more duplicate ResourcesAdded values in the Shops API (these are on us2, aka PVP Global):

Port=La Habana [38], Item=Iberian Dried Pork [790]

Port=Kingston / Port Royal [79], Item=Lancashire Iron [806]

Port=Les Gonaïves [93], Item=Fine Fabrics [824]

Port=La Tortue [96], Item=Provence Oak [829]

Port=Fajardo [116], Item=Iberian Dried Pork [790]

Port=Christiansted [129], Item=Norwegian Fox Fur [819]

Port=Gustavia [133], Item=Cape Coast Honey [833]

Port=La Désirade [139], Item=Languedoc Violins [825]

Port=Fort-Royal [156], Item=Corsican Mint [823]

Port=Carriacou [163], Item=Textile Machinery [811]

Port=Cartagena de Indias [212], Item=Spanish Dried Fruits [796]

Port=Atchafalaya [294], Item=Normandy Cider [827]

It is unclear what to do when the same item is found in the list twice. Should the correct value be taken as the first one in the list, the last one in the list, or the sum of all the entries with the same item id?

(sorry if formatting is bad, I still have that bug that removes all styles from the forum web pages) Edited August 5, 2017 by Taralin Snow

Taralin Snow · August 9, 2017

to answer my own question:

When the same Item ID appears twice in a ResourcesAdded array, then both entries apply. The daemon that processes these lists does not appear to notice or care that it already saw that item in that port previously, when it reaches the duplicate entry.

jodgi · August 29, 2017

Halp, pls!

I would like to set up a way to extract the speed data from the api file after a patch or when changes are made. It would be cool to make it fairly auto, but it doesn't have to be full auto. I'm aware of bash scripts, grep, regex and some fancy editors but I'm afraid I do not know all that well enough to make it do what I want. I'm pretty sure some of you in here could, though.

Here's the idea in my head:

This is the part of the apt file I'm looking for:

{"__type":"MegaChaka.Services.Items.ShipTemplate, MegaChaka","RepairPriceCoefficient":0.1,"Class":6,"ShipTemplateName":"Brig","Specs":{"MaxPassableHeight":3,"MaxSpeed":169.487991333008,"MaxTurningSpeed":16.6299991607666,"Acceleration":0.5,"Deceleration":0.5,"SpeedToWind":[0.907904624938965,0.9187992811203,0.973850250244141,0.995810508728027,0.953455448150635,0.945964455604553,0.907043993473053,0.674097657203674,0.49501097202301,0.57897675037384,0.323229432106018,0.239175021648407,-0.259320199489594],

For now I'd like to isolate every occurence of

"ShipTemplateName":"Brig"

and the related

"SpeedToWind":[0.907904624938965,0.9187992811203,0.973850250244141,0.995810508728027,0.953455448150635,0.945964455604553,0.907043993473053,0.674097657203674,0.49501097202301,0.57897675037384,0.323229432106018,0.239175021648407,-0.259320199489594],

^This is the meat of the matter but it would be helpful to include the "ShipTemplateName":"..." of every "SpeedToWind":[...]

Anything is *simple* for those who know how to do it Maybe @Black Spawn, @Remus, @Prater, @qw569, @balticsailor, @BungeeLemming, @woodenfish or any of you other technical guys could help me out?

qw569😳 · August 29, 2017

2 hours ago, jodgi said:
Halp, pls!

I would like to set up a way to extract the speed data from the api file after a patch or when changes are made. It would be cool to make it fairly auto, but it doesn't have to be full auto. I'm aware of bash scripts, grep, regex and some fancy editors but I'm afraid I do not know all that well enough to make it do what I want. I'm pretty sure some of you in here could, though.

Here's the idea in my head:

This is the part of the apt file I'm looking for:
{"__type":"MegaChaka.Services.Items.ShipTemplate, MegaChaka","RepairPriceCoefficient":0.1,"Class":6,"ShipTemplateName":"Brig","Specs":{"MaxPassableHeight":3,"MaxSpeed":169.487991333008,"MaxTurningSpeed":16.6299991607666,"Acceleration":0.5,"Deceleration":0.5,"SpeedToWind":[0.907904624938965,0.9187992811203,0.973850250244141,0.995810508728027,0.953455448150635,0.945964455604553,0.907043993473053,0.674097657203674,0.49501097202301,0.57897675037384,0.323229432106018,0.239175021648407,-0.259320199489594],
For now I'd like to isolate every occurence of
"ShipTemplateName":"Brig"
and the related
"SpeedToWind":[0.907904624938965,0.9187992811203,0.973850250244141,0.995810508728027,0.953455448150635,0.945964455604553,0.907043993473053,0.674097657203674,0.49501097202301,0.57897675037384,0.323229432106018,0.239175021648407,-0.259320199489594],
^This is the meat of the matter but it would be helpful to include the "ShipTemplateName":"..." of every "SpeedToWind":[...]

Anything is *simple* for those who know how to do it Maybe @Black Spawn, @Remus, @Prater, @qw569, @balticsailor, @BungeeLemming, @woodenfish or any of you other technical guys could help me out?

My command line Kung Fu

require curl and jq

	curl http://storage.googleapis.com/nacleanopenworldprodshards/ItemTemplates_cleanopenworldprodeu1.json | cut -c21- | jq -r ".[]|select(.ShipTemplateName!= null)|[.ShipTemplateName,.Specs.SpeedToWind[]]|@csv"

Another variant without error message. Require sed

	 curl http://storage.googleapis.com/nacleanopenworldprodshards/ItemTemplates_cleanopenworldprodeu1.json | sed "s/^.\{20\}//" | sed "s/.\{1\}$//" | jq -r ".[]|select(.ShipTemplateName!= null)|[.ShipTemplateName,.Specs.SpeedToWind[]]|@csv"

Output like csv

	"Ocean",0.787681877613068,0.901673376560211,0.970308780670166,0.995838046073914,0.961763143539429,0.862410068511963,0.764305830001831,0.477654784917831,0.209703385829926,0.186606153845787,0.167434334754944,0.11640040576458,-0.11904639005661
"RattlesnakeHeavy",0.819048285484314,0.909329354763031,0.97773540019989,0.995458722114563,0.943179130554199,0.922312438488007,0.893748581409454,0.754612565040588,0.569385051727295,0.519350707530975,0.413033157587051,0.253520905971527,-0.179818704724312
"TradersBrig",0.907904624938965,0.9187992811203,0.973850250244141,0.995810508728027,0.953455448150635,0.945964455604553,0.907043993473053,0.674097657203674,0.49501097202301,0.57897675037384,0.323229432106018,0.239175021648407,-0.259320199489594

Edited August 29, 2017 by qw569

jodgi · August 29, 2017

24 minutes ago, qw569 said:


	curl http://storage.googleapis.com/nacleanopenworldprodshards/ItemTemplates_cleanopenworldprodeu1.json | cut -c21- | jq -r ".[]|select(.ShipTemplateName!= null)|[.ShipTemplateName,.Specs.SpeedToWind[]]|@csv"

Whoa, that was quick! Short and sweet too. I'll get right on it...

edit:

Boom! Just like that, fantastic!

"Yacht",0.670284867286682,0.738820016384125,0.740775346755981,0.747335135936737,0.845197737216949,0.948317110538483,0.99591600894928,0.882352113723755,0.875755369663239,0.921960532665253,0.712887465953827,0.446366399526596,-0.0462989956140518
"Bellona",0.816375613212585,0.936930894851685,0.988107442855835,0.996643424034119,0.942412972450256,0.877267062664032,0.868031620979309,0.726795315742493,0.44377401471138,0.361215323209763,0.241659790277481,0.0903672203421593,-0.140772551298141
"Cerberus",0.897633910179138,0.918979048728943,0.974961340427399,0.997262418270111,0.94380784034729,0.922044157981873,0.893744826316834,0.754612565040588,0.569385051727295,0.519350707530975,0.406001746654511,0.238203302025795,-0.179818704724312
"Niagara",0.830660879611969,0.912714421749115,0.972128987312317,0.99762225151062,0.957572162151337,0.896801114082336,0.975587129592896,0.810507297515869,0.630711197853088,0.567409038543701,0.437655121088028,0.243285745382309,-0.259320199489594
"BellePoule",0.832115113735199,0.908546209335327,0.976568460464478,0.996262609958649,0.951885640621185,0.924183785915375,0.852216601371765,0.714987337589264,0.564436972141266,0.476606905460358,0.340712279081345,0.166779562830925,-0.0960397943854332
"Hermione",0.816173374652863,0.894985318183899,0.968717694282532,0.99427318572998,0.964730858802795,0.921610474586487,0.928746402263641,0.832743287086487,0.677251100540161,0.50856339931488,0.258964389562607,0.168681815266609,-0.212512999773026
"GunBoat",0.640058934688568,0.740776479244232,0.775078654289246,0.804588258266449,0.87659740447998,0.93079686164856,0.997636556625366,0.89802485704422,0.908320128917694,0.970084309577942,0.473437815904617,0.475712299346924,-4.07380030083004e-05
"Brig",0.907904624938965,0.9187992811203,0.973850250244141,0.995810508728027,0.953455448150635,0.945964455604553,0.907043993473053,0.674097657203674,0.49501097202301,0.57897675037384,0.323229432106018,0.239175021648407,-0.259320199489594
"Rattlesnake",0.805158197879791,0.856941342353821,0.949949443340302,0.995938658714294,0.96014392375946,0.947647333145142,0.891575217247009,0.79248571395874,0.655579805374146,0.516388893127441,0.391414910554886,0.190061628818512,-0.19681841135025
"Endymion",0.792031824588776,0.910826086997986,0.974677681922913,0.99725329875946,0.961072504520416,0.83906102180481,0.696992337703705,0.63578075170517,0.558015942573547,0.422619998455048,0.258599698543549,0.146300345659256,-0.212512999773026
"Santisima",0.780579745769501,0.905760586261749,0.992659687995911,0.999634623527527,0.962262809276581,0.875864505767822,0.758958458900452,0.466653943061829,0.20929890871048,0.182290479540825,0.152640506625175,0.0910464152693748,-0.11958584189415
"Pickle",0.869210362434387,0.860205590724945,0.860346019268036,0.870565891265869,0.866416037082672,0.934467494487762,0.998558342456818,0.841611683368683,0.900335371494293,0.934787213802338,0.441632241010666,0.389370560646057,-0.0869158059358597
"YachtSilver",0.670284867286682,0.738820016384125,0.740775346755981,0.747335135936737,0.845197737216949,0.948317110538483,0.99591600894928,0.882352113723755,0.875755369663239,0.921960532665253,0.712887465953827,0.446366399526596,-0.0462989956140518
"Ingermanland",0.911585807800293,0.971969425678253,0.993132770061493,1.00037217140198,0.972440004348755,0.93043464422226,0.874004364013672,0.743567526340485,0.537364661693573,0.426011860370636,0.300232023000717,0.156852394342422,-0.140772551298141
"Surprise",0.811527490615845,0.89701509475708,0.970561981201172,0.996279835700989,0.958436250686646,0.963130474090576,0.938672959804535,0.845285594463348,0.685657560825348,0.509530544281006,0.35595914721489,0.163164660334587,-0.196165829896927
"BasicLynx",0.532278835773468,0.646284937858582,0.734185039997101,0.760524809360504,0.812957763671875,0.93157172203064,1.00052952766418,0.927837312221527,0.925526201725006,0.996561944484711,0.838097333908081,0.53007984161377,-0.0525373816490173
"TradersCutter",0.728494167327881,0.790638506412506,0.813238978385925,0.813403606414795,0.857197999954224,0.950983881950378,0.997444868087769,0.945230484008789,0.983980417251587,0.989391446113586,0.700145483016968,0.424478948116302,-0.0562432110309601
"Bucentaure",0.792798578739166,0.934872031211853,0.979838013648987,0.996067643165588,0.942314028739929,0.907004714012146,0.877773106098175,0.726127088069916,0.453525632619858,0.358104646205902,0.255109310150146,0.118876300752163,-0.129784807562828
"TradersSnow",0.972789466381073,0.957600355148315,0.960616827011108,1.0002852678299,0.824447214603424,0.827346682548523,0.946956813335419,0.76895272731781,0.63469785451889,0.582274436950684,0.472966611385345,0.262696743011475,-0.249456852674484
"BasicCutter",0.728494167327881,0.790638506412506,0.813238978385925,0.813403606414795,0.857197999954224,0.950983881950378,0.997444868087769,0.945230484008789,0.983980417251587,0.989391446113586,0.700145483016968,0.424478948116302,-0.0562432110309601
"Frigate",0.833000004291534,0.908535003662109,0.977411866188049,0.996864318847656,0.962958753108978,0.941396236419678,0.867685437202454,0.730434000492096,0.58012443780899,0.493259966373444,0.349891006946564,0.157746911048889,-0.0968957170844078
"PirateFrigate",0.833000004291534,0.908339619636536,0.975726366043091,0.995813369750977,0.962218582630157,0.926429688930511,0.950867652893066,0.821462154388428,0.615883946418762,0.493259966373444,0.349891006946564,0.171594694256783,-0.0968957170844078
"Privateer",0.54330050945282,0.63318920135498,0.68184107542038,0.684400498867035,0.717579066753387,0.808612704277039,0.952417373657227,0.903252720832825,0.919994592666626,1.00288152694702,0.792346060276031,0.495566010475159,-0.0578065179288387
"Indiaman",0.911585807800293,0.971969425678253,0.993132770061493,1.00037217140198,0.972440004348755,0.93043464422226,0.874004364013672,0.743567526340485,0.537364661693573,0.426011860370636,0.300232023000717,0.156852394342422,-0.140772551298141
"Constitution",0.86933159828186,0.96128511428833,0.990749180316925,0.998433411121368,0.953931629657745,0.924036920070648,0.842626214027405,0.683046936988831,0.509362399578094,0.441176950931549,0.310167133808136,0.164526998996735,-0.075474388897419
"Agamemnon",0.857732713222504,0.942265391349792,0.974424362182617,0.999182939529419,0.937313795089722,0.907193541526794,0.871875464916229,0.731563150882721,0.481307208538055,0.398183107376099,0.286346852779388,0.139497011899948,-0.129784807562828
"RookieBrig",0.907904624938965,0.9187992811203,0.973850250244141,0.995810508728027,0.953455448150635,0.945964455604553,0.907043993473053,0.674097657203674,0.49501097202301,0.57897675037384,0.323229432106018,0.239175021648407,-0.259320199489594
"Hamburg",0.907776474952698,0.958565413951874,0.982138693332672,0.997209966182709,0.976651847362518,0.92186564207077,0.885603487491608,0.757991135120392,0.539167761802673,0.43432354927063,0.332670390605927,0.155216112732887,-0.151661023497581
"Lhermione",0.877424120903015,0.964398622512817,0.973493456840515,1.00120043754578,0.969609379768372,0.895467102527618,0.841859221458435,0.718162655830383,0.542236685752869,0.436647295951843,0.323266595602036,0.169001549482346,-0.10212404280901
"Snow",0.972789466381073,0.957600355148315,0.960616827011108,1.0002852678299,0.824447214603424,0.827346682548523,0.946956813335419,0.76895272731781,0.63469785451889,0.582274436950684,0.472966611385345,0.262696743011475,-0.249456852674484
"Pavel",0.792188942432404,0.93561065196991,0.989476144313812,0.974980115890503,0.896185576915741,0.822847306728363,0.846558094024658,0.702219367027283,0.435774922370911,0.358989179134369,0.236988544464111,0.0913731530308723,-0.139976561069489
"TradersLynx",0.532278835773468,0.646284937858582,0.734185039997101,0.760524809360504,0.812957763671875,0.93157172203064,1.00052952766418,0.927837312221527,0.925526201725006,0.996561944484711,0.838097333908081,0.53007984161377,-0.0525373816490173
"Lynx",0.532278835773468,0.646284937858582,0.734185039997101,0.760524809360504,0.812957763671875,0.93157172203064,1.00052952766418,0.927837312221527,0.925526201725006,0.996561944484711,0.838097333908081,0.53007984161377,-0.0525373816490173
"PrincedeNeufchatel",0.848778426647186,0.958301663398743,0.999357461929321,0.976577162742615,0.954367458820343,0.984639763832092,0.996483445167542,0.930646538734436,0.786815643310547,0.712929487228394,0.527663350105286,0.325583338737488,-0.0722597166895866
"Renommee",0.795650064945221,0.89810311794281,0.973023891448975,0.996667683124542,0.960921287536621,0.92350822687149,0.85180652141571,0.719530642032623,0.575601875782013,0.483865916728973,0.360899329185486,0.1506028175354,-0.0968957170844078
"RookieSnow",0.972789466381073,0.957600355148315,0.960616827011108,1.0002852678299,0.824447214603424,0.827346682548523,0.946956813335419,0.76895272731781,0.63469785451889,0.582274436950684,0.472966611385345,0.262696743011475,-0.249456852674484
"Cutter",0.728494167327881,0.790638506412506,0.813238978385925,0.813403606414795,0.857197999954224,0.950983881950378,0.997444868087769,0.945230484008789,0.983980417251587,0.989391446113586,0.700145483016968,0.424478948116302,-0.0562432110309601
"Bellona74",0.816375613212585,0.936930894851685,0.988107442855835,0.996643424034119,0.942412972450256,0.877267062664032,0.868031620979309,0.726795315742493,0.44377401471138,0.361215323209763,0.241659790277481,0.0903672203421593,-0.140772551298141
"Trincomalee",0.832170903682709,0.902271628379822,0.985888719558716,0.989868223667145,0.970807313919067,0.940806329250336,0.840245366096497,0.689770102500916,0.515985190868378,0.419675171375275,0.324815839529037,0.163178458809853,-0.0968957170844078
"Victory",0.816791236400604,0.905348181724548,0.980737447738647,0.998140692710876,0.973226845264435,0.915085315704346,0.849262416362762,0.696688413619995,0.427220493555069,0.249354660511017,0.161347717046738,0.0935477539896965,-0.129566252231598
"Wasa",0.903700172901154,0.964088678359985,0.988447427749634,0.999410033226013,0.97262442111969,0.930889248847961,0.875492870807648,0.744813442230225,0.539288103580475,0.428293406963348,0.300232023000717,0.156852394342422,-0.140772551298141
"Mercury",0.813431262969971,0.905767142772675,0.972116589546204,0.998867750167847,0.960777461528778,0.896881699562073,0.979514062404633,0.821292281150818,0.661518633365631,0.608943700790405,0.457717478275299,0.240569084882736,-0.259320199489594
"Essex",0.833995461463928,0.910735547542572,0.973840832710266,0.99613630771637,0.965568840503693,0.92396092414856,0.892918765544891,0.783014595508575,0.614684402942657,0.437216997146606,0.25872129201889,0.168681815266609,-0.212512999773026
"Indefatiable",0.877352893352509,0.935259401798248,0.973200798034668,1.00120043754578,0.969609379768372,0.897990822792053,0.843265891075134,0.698419153690338,0.532202363014221,0.436647295951843,0.323266595602036,0.169001549482346,-0.10212404280901
"GrosVentre",0.913928985595703,0.963385879993439,0.986935496330261,1.00089359283447,0.987335562705994,0.971958696842194,0.925983369350433,0.930244982242584,0.795269072055817,0.515271663665771,0.397909581661224,0.211106672883034,-0.100666999816895
"Pandora",0.792188942432404,0.93561065196991,0.989476144313812,0.974980115890503,0.896185576915741,0.841043531894684,0.887555301189423,0.73204243183136,0.446264714002609,0.358989834785461,0.236988544464111,0.0913731530308723,-0.139976561069489
"BrigMR",0.826148629188538,0.912718594074249,0.973850250244141,0.995810508728027,0.953455448150635,0.945964455604553,0.907043993473053,0.674097657203674,0.474649310112,0.501676023006439,0.323229432106018,0.239175021648407,-0.259320199489594
"NavyBrig",0.826148629188538,0.912718594074249,0.973850250244141,0.995810508728027,0.953455448150635,0.945964455604553,0.907043993473053,0.674097657203674,0.49501097202301,0.57897675037384,0.323229432106018,0.239175021648407,-0.259320199489594
"Ocean",0.787681877613068,0.901673376560211,0.970308780670166,0.995838046073914,0.961763143539429,0.862410068511963,0.764305830001831,0.477654784917831,0.209703385829926,0.186606153845787,0.167434334754944,0.11640040576458,-0.11904639005661
"RattlesnakeHeavy",0.819048285484314,0.909329354763031,0.97773540019989,0.995458722114563,0.943179130554199,0.922312438488007,0.893748581409454,0.754612565040588,0.569385051727295,0.519350707530975,0.413033157587051,0.253520905971527,-0.179818704724312
"TradersBrig",0.907904624938965,0.9187992811203,0.973850250244141,0.995810508728027,0.953455448150635,0.945964455604553,0.907043993473053,0.674097657203674,0.49501097202301,0.57897675037384,0.323229432106018,0.239175021648407,-0.259320199489594

jodgi · August 29, 2017

Crap! I forgot all about max speed... @qw569, could I bother you to sneak that in? Looking at the syntax I'm still not sure how to do it.

qw569😳 · August 29, 2017

2 minutes ago, jodgi said:

Crap! I forgot all about max speed... @qw569, could I bother you to sneak that in? Looking at the syntax I'm still not sure how to do it.

	curl http://storage.googleapis.com/nacleanopenworldprodshards/ItemTemplates_cleanopenworldprodeu1.json | sed "s/^.\{20\}//" | sed "s/.\{1\}$//" | jq -r ".[]|select(.ShipTemplateName!= null)|[.ShipTemplateName,.Specs.MaxSpeed,.Specs.SpeedToWind[]]|@csv"

jodgi · August 29, 2017

Thanks! I wish I was a better *nix guy, it's so cool. :-D

woodenfish · October 18, 2017

Can we please have the id/name pairs for the new countries so that I can update my maps at theroyaltraderscompany.com?

10 = ?

11 = Prussia

12 = ?

Edited October 18, 2017 by woodenfish
Extra info

qw569😳 · October 19, 2017

10 hours ago, woodenfish said:

Can we please have the id/name pairs for the new countries so that I can update my maps at theroyaltraderscompany.com?

10 = ?

11 = Prussia

12 = ?

Id	Name
0	Neutral
1	Pirates
2	España
3	France
4	Great Britain
5	Verenigde Provinciën
6	Danmark-Norge
7	Sverige
8	United States
9	Free Town
10	Russian Empire
11	Kingdom of Prussia
12	Commonwealth of Poland

October 19, 2017

@qw569

You seem to be an expert on using the API. Is it possible to setup a system for the API data to be linked to a google sheet, so that a change in the data would automatically update on the google sheet?

If yes, would you mind giving me a brief summary of how to set something like this up? I have experience programming with Python and JavaScript, and I know excel very well, but the API format and syntax is new to me.

qw569😳 · October 19, 2017

29 minutes ago, EliteDelta said:

@qw569

You seem to be an expert on using the API. Is it possible to setup a system for the API data to be linked to a google sheet, so that a change in the data would automatically update on the google sheet?

If yes, would you mind giving me a brief summary of how to set something like this up? I have experience programming with Python and JavaScript, and I know excel very well, but the API format and syntax is new to me.

Look at UrlFetchApp.fetch, JSON.parse

I made brief example how to get data from Ports_cleanopenworldprodeu1.json to google sheet. Make a copy this spreadsheet and look Tools -> Script Editor.

Bart Smith · October 19, 2017

Hi i have no clue about api. Anyone for PotBS remember armeagle website? That was brilliant way to check what going on in game, showing conquest and map when you cant log in into game. Wonder similar website can be made using api? Sadly cant send lonk website is dead

October 20, 2017

18 hours ago, qw569 said:

Look at UrlFetchApp.fetch, JSON.parse

I made brief example how to get data from Ports_cleanopenworldprodeu1.json to google sheet. Make a copy this spreadsheet and look Tools -> Script Editor.

Thanks for your advice.

A bit confused by your example sheet though, there doesn't seem to be anything in the Script Editor section of that sheet...

Norfolk nChance · October 20, 2017

1 minute ago, EliteDelta said:

Thanks for your advice.

A bit confused by your example sheet though, there doesn't seem to be anything in the Script Editor section of that sheet...

same here, you need to save a copy first then re-open your COPY. Then Scrpt Editor you need to start it...

am old and won't change from my excel 2016

October 20, 2017

15 minutes ago, Norfolk nChance said:

same here, you need to save a copy first then re-open your COPY. Then Scrpt Editor you need to start it...

am old and won't change from my excel 2016

So you saved a Copy of the example sheet. Then reopened it, and then there was something in the script editor section? I cant seem to make it work.. Could you copy and paste it?

Norfolk nChance · October 20, 2017

1. Double click his "example"
2. File > Make a COPY > OK
3. CLOSE his orginal sheet
4. Go to your COPY > Tools
5. Script Editor >
6. A second sheet appears called "> getData". You should see @qw569 macro
7. [Run] to run the macro. This will lead into your Google a/c login id. click "getData" to continue
8. Pop-up "got it"

9. you might need to go to advanced settings here bottom left and click Go to getData(unsafe)
10. You'll be asked to then type in "Continue" and then "allow"
11. Go back to sheet and the ports should have dropped in...

sorry for the sucking eggs stages...

Norfolk.

October 20, 2017

Haha I see my mistake now. I copied it to an existing sheet of mine, instead of creating a new one altogether. Strange that it made such a difference... Anyway, thanks @Norfolk nChance!

Smoothy · October 22, 2017

On 19/10/2017 at 7:59 AM, qw569 said:

Look at UrlFetchApp.fetch, JSON.parse

I made brief example how to get data from Ports_cleanopenworldprodeu1.json to google sheet. Make a copy this spreadsheet and look Tools -> Script Editor.

Based on this example I amended the script to pull data from the Shops file and the port ID is returned but the Template and Amount fields populate as undefined. What am I doing wrong?

qw569😳 · October 23, 2017

18 hours ago, Smoothy said:

Based on this example I amended the script to pull data from the Shops file and the port ID is returned but the Template and Amount fields populate as undefined. What am I doing wrong?

I supoose i need to see your code

Smoothy · October 23, 2017

15 minutes ago, qw569 said:

I supoose i need to see your code

Sorry. Now sent in PM.

Norfolk nChance · October 24, 2017

@qw569

I know you are very busy, but if you could find time to do a small “Idiots Guide to NA API…” it would be really helpful to old farts like myself who are too old to program.

You’ve helped me so much am sure others would like your insights and knowledge as well

Norfolk nCode

CTC_ClanLeader · December 6, 2017

Does someone has an idea where to find the countys whithin the api? Found the Region (Port.Location) but no countys.

Would like to filter by county, to see wich ports in the area have the stuff i need.

qw569😳 · December 7, 2017

13 hours ago, CTC_ClanLeader said:

Does someone has an idea where to find the countys whithin the api? Found the Region (Port.Location) but no countys.

Would like to filter by county, to see wich ports in the area have the stuff i need.

I use a substitution table like below

CountyCapitalName from API. County from map in game.

West End	Grand Bahama
Marsh Harbour	Abaco
Morgan's Bluff	Andros
Nassau	New Providence
George's Town	Exuma
Pitt's Town	Crooked

CTC_ClanLeader · December 7, 2017

:/ thanks. Any plans @admin to at the county to the api?

@qw569

can u post ur list so i can spare some time by searching for it?

Edited December 7, 2017 by CTC_ClanLeader

Public "API" for Naval Action

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

raskolnikoff

Jan van Santen

Grim DeGrim

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites