Please guide me how to use api to extract data?

[BReddy_m]

How to generate api key and how to extract data from an restfull api using UiPath studio.

[Gokul001 (Gokul Balaji)]

Hi @BReddy_m

@BReddy_m

How to generate api key

• API key is a unique identifier that is used to authenticate requests to an API.

• To generate an API key, you need to use the CreateKey method of the Google Cloud Platform (GCP) Console.

Check out this : Creating and managing API keys  |  API Keys API Documentation  |  Google Cloud

@BReddy_m

how to extract data from an restfull api using UiPath studio.

• You need to use an HTTP Request activity that allows you to manipulate REST APIs using the HTTP Request Wizard.

• You also need to use a Deserialize JSON activity that converts a JSON string into a JSON object.

• You can then use other activities such as Write Range or Write CSV to write the data to Excel/CSV files.

Check out this video link

UiPath | Make REST API calls, JSON parsing and write to Excel/CSV | Tutorial

Regards
Gokul

[ushu (Usha kiranmai)]

Hi @BReddy_m Please check the below link for better understanding

API : UiPath API Automation - Get, Create, Update and Delete Request Methods

[BReddy_m]

Let me say I have a private restfull API, for this API where can I get the API key to get the data?

[ABHIMANYU_THITE1 (ABHIMANYU THITE)]

Thanks @Gokul001 and @ushu for wonderful tutorials!

[FIROZ_RANGREZ]

Hi @BReddy_m,

You have to read the documentation for that API they will tell you which type of authentication methods they support, as API key mechanism is one type of authentication mechanism.

Let me know if you have further queries.

Regards,
Firoz