Discussion REST API for system data?
- Thread starter jgm
- Start date
Thanks, but I'm trying to avoid downloading 20MB per client to pull a very small amount of data. Will keep looking.
Well, if you Inspect the eddb page, you can see that the station search goes like this (e.g. "jameson"):
Code:
https://eddb.io/station/search?station%5Bname%5D=jameson&expand=system&_=1453305835620This returns a JSON array of matches with EDDB id's:
Code:
[{"id":571,"name":"Jameson Memorial","system_id":16827,"max_landing_pad_size":"L","distance_to_star":346,"faction":"The Pilots Federation","government":"Democracy","allegiance":"Independent","state":"None","type_id":8,"type":"Orbis Starport","has_blackmarket":0,"has_market":1,"has_refuel":1,"has_repair":1,"has_rearm":1,"has_outfitting":1,"has_shipyard":1,"has_commodities":1,"import_commodities":["Cobalt","Rutile","Natural Fabrics"],"export_commodities":["Hydrogen Fuel","Microbial Furnaces","Power Generators"],"prohibited_commodities":["Narcotics","Combat Stabilisers","Imperial Slaves","Slaves","Personal Weapons","Battle Weapons","Toxic Waste"],"economies":["High Tech","Industrial"],"updated_at":1444494454,"shipyard_updated_at":1453302164,"outfitting_updated_at":1453304743,"market_updated_at":1453304740,"is_planetary":0,"selling_ships":["Adder","Anaconda","Asp Explorer","Cobra Mk. III","Diamondback Explorer","Diamondback Scout","Eagle Mk. II","Federal Assault Ship","Federal Dropship","Federal Gunship","Fer-de-Lance","Hauler","Imperial Clipper","Imperial Courier","Imperial Eagle","Orca","Python","Sidewinder Mk. I","Type-6 Transporter","Type-7 Transporter","Type-9 Heavy","Viper Mk III","Vulture","Asp Scout","Federal Corvette","Imperial Cutter","Keelback","Viper MK IV","Cobra MK IV"],"selling_modules":[738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537],"system":{"id":16827,"name":"Shinrarta Dezhra","x":55.71875,"y":17.59375,"z":27.15625,"faction":"The Pilots Federation","population":85206935,"government":"Democracy","allegiance":"Independent","state":"None","security":"High","primary_economy":"High Tech","power":"?","power_state":"?","needs_permit":1,"updated_at":1451665547,"simbad_ref":""}}]Which contains the info you seem to be looking for. If you use this URL using the EDDB station id, you get the full info in HTML format (where 571 is Jameson Memorial):
Code:
https://eddb.io/station/571HTH
Interesting; thanks for this. All I have to start with is the system name so I'm trying to obtain the systems whose name are an exact match. I tried
Code:
https://eddb.io/system/search?system[multiname]=maia&_=1453306384039But it returns anything with a substring match. I tried various options instead of multiname but didn't have any luck; is there something that will only return exact matches?
Also, this returns the systems and their stations but doesn't return the extended system data. How can I pull the extended system data at the same time? I know I could run another request but would prefer to keep volume down if at all possible.
Finally, I assume that the number is a timestamp. IS this correct?
That works. But when I asked themroc he said that this and the system search are not supported APIs, and will go away at some point.
So use at your own risk (and the risk of ing off themroc).
Last edited:
Pah. Fair enough though; I'll just have to put something together myself. Thanks for the info.
Slight ot question, but does the availability of this db mean that we can find out where all the earth likes or bh's are? Or is it just the inhabited systems?
Last edited:
The independent use of https://eddb.io/station/search is not recommended. It is not officially supported and not meant to be used from other 3rd party tools. However, I can deliver a special dump with only a minimum set of data as CSV if required. That would be way smaller and faster to download/process. Also, I recommend to mirror any nightly dump to your own server which then serves your userbase.
Can you please describe what data you need? You can hit me up on chat too: https://kiwiirc.com/client/irc.quakenet.org/eddb
Can you please describe what data you need? You can hit me up on chat too: https://kiwiirc.com/client/irc.quakenet.org/eddb
I've been chided for hacking your site
Maybe he could use your station dump to get the eddb id, and then just do a GET on the https://eddb.io/station/<insert id here> URL. Avoids the search.