Do you consider subscribing Starlink? In this blog, we will use Starlink API to get all the satellites data.
SpaceX API provides an all-in-one endpoint to query all Starlink satellites at one time, with no pagination, authentication etc.
So, in the first “Text Input” tool below, the only input text is the endpoint: https://api.spacexdata.com/v4/starlink
By using the “Download” tool, we can get all the data from the endpoint, and in the Payload tab, we need to select the HTTP Action as “GET (or FTP)”.
For the 3rd “JSON Parse” tool, it transfers the downloaded data into a table format.
In order to transform the data into the format we wanted, we use “Text Into Columns” tool to separate the data into different columns. As shown in below image: we want to have all the field names in “JSON_Name3” column to make a transpose transformation in the next step, but some of the field names are in “JSON_Name2” columns but the cell in the same row in “JSON_Name3” is NULL.
So we configure the “Multi-Field Formula” tool as shown below:
For the “Cross Tab” tool next, we aggregate the data by “JSON_Name1” column and all the other values for other columns are from “JSON_ValueString”.
Then we can output it as a excel file.