How to Connect to Galileo Using Postman

Who is this article for?

 Coruson administrators or data scientists.

 Access keys for Galileo are required.

Galileo is Ideagen's data warehouse for Coruson, which allows you to connect and perform your own analysis of your Coruson data.

This article outlines the steps required to connect to Galileo using Postman. Postman is an API tool that will allow you to make API calls within Galileo. Postman does not allow you to perform any analysis but can be used to access the data in a JSON format which you can then use in other analytic tools.

This does not provide details on specific steps on how to use the JSON data and instead focuses on how to access the data.

To make connecting to Galileo easier to learn, this article is split into 4 sections so that you can either walk through the steps in sequence or you can jump to the section relevant to what you are doing with Galileo:

1. Install Postman
2. Connect to Galileo
3. Querying Specific Tables
4. Further Reading

Before you proceed, please ensure you have your data warehouse URL and the access keys for Galileo. For details on how to request these please visit How to Request Galileo Access.

1. Install Postman

If you don't already have Postman installed then it can be downloaded for free from Postman.com.

1. Browse to the Postman app of the Postman website.
2. Download and install the app.

More Assistance: For more assistance in installing Postman please visit the Postman Docs.

2. Connect Using Postman

With Postman installed and your keys on hand you are ready to connect to Galileo.

To connect:

1. Open Postman.
2. Open a new connection tab.
3. Enter the URL for your Galileo tenant.
4. Click on the Authorization tab.
5. Update the Key field as X-IdeagenDataAPIKey.
6. Update the Value field with the key supplied to you by Ideagen.
7. Update the Add To field to Header.

4. Click Send.

If your connection has been successful you will then see a list of all tables available in Galileo in the Body section.

3. Querying Specific Tables

To query specific tables:

1. Confirm you can connect to Galileo via the above steps.
2. Update your GET request with the name of the table you want to query.
3. Click Send.

4. Further Reading

• Getting Started with Galileo
• Galileo Technical Overview
• Galileo Responses & Usage Limits
• How to Request Galileo Access
• How to Connect to Galileo Using Microsoft Power BI
• How to Build Table Relationships in Galileo using Power BI
• How to Connect to Galileo Using Microsoft Excel
• Microsoft Power BI website