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.

Yi Gao
Author: Yi Gao

Yi has a master’s degree in data science from The University of Sydney and a background in engineering and manufacturing. She is passionate about finding insights from large and diverse datasets and applying them to real-world scenarios. In her previous role at Daimler China, she analysed vehicle usage data, provided recommendations and created dashboard for internal customers. In her spare time, she enjoys photography, especially of animals and her two sons, and cooking traditional Chinese food.