HTTP Request

Node used to perform an HTTP request.

The node structure includes components such as:

Request Method

The request method (GET, POST, etc.)

Request URL

The request URL address.

Content Type

There are 4 content types to choose from:

• text/plain: plain text format, without special formatting or encoding.
• application/json: JSON data format, commonly used for data transfer between server and client.
• multipart/form-data: represents Multipart form, this encoding type is used when users want to upload data files.
• application/x-www-form-urlencoded: the default encoding type if the enctype attribute has no value, representing URL Encoded Form. All characters are encoded before sending (spaces are converted to "+" or "%20" symbols, and special characters are converted to ASCII HEX values).

Use Cache

Store the returned value when the execution is successful, and in the next run, use the previously returned value instead of making a new HTTP request.

Use Profile Proxy

Use the profile's proxy when performing an HTTP request.

Timeout

The timeout duration for performing the HTTP request, select 0 for no timeout.

Headers

To authenticate when using the API if necessary. For example, if I need to authenticate using a Bearer token like:

Authorization:Bearer hfkasf2938safjkb,bfclsaidfcf,jsacbliwgsbdcjsacsdakhfasjbasdfhfakjsfdbcasdfgasfbasdfhbfcbashdagdkbsajfhgdsb.

I will fill it in the node as follows:

Writing Expressions in Content

When writing expressions within the content to access data such as variables, tables, etc., it’s a bit challenging because the final result must be valid JSON. To avoid the "Invalid JSON content" error, I need to wrap the expression in the $stringify function.

Response

After receiving the returned data from the API call, I need to process it for use. This section includes some information to note, such as:

• Response Type Select the response data type, default is JSON.

• Data Path When selecting the JSON response type, I can configure the path of the desired data. For example, when the response returns this data:

	{
		"status": 200,
		"data": {
			"name": "Prices",
			"values": [
				{ "id": 1, "value": 4000 },
				{ "id": 2, "value": 24000 }
			]
		}
	}

• If I want to retrieve the value of the values array, use the syntax data.values. To get the first value of the values array, use the syntax data.values.0.

• If I want to use all the returned values as above, leave the Data path field blank.

• Assign to Variable You can assign the value to a variable.

• Variable Name The variable name to assign the value to. This field appears when I choose to assign to a variable.

• Insert into Table You can insert the value into a column in a table.

• Select Column The column where the value is inserted. This field appears when I choose to insert into a table.

• Add Additional Row Insert an additional row into a column in a table.

Practical Example

Calling API to Get Phone Number and Receive Code

Example

In practical cases, using the HTTP Request node depends on the provided API. Therefore, this example is performed to help me better understand the use of this node in a specific case. The example below will use the API of the website http://ktool.site/ to rent a phone number and retrieve the code sent to that rented phone number.

• API to Get Phone Number In the request method section, I use the GET method to retrieve the value. The Request URL is the provided API address to get the phone number; on this website, the address format is: http://ktool.site/api/v1/thueso/create?tokenid={my token}&quocgia={vn1 or vn2 or cam...}&dichvu={Google or Discord or Telegram....}, I can adjust the options to complete the API address, for example: http://ktool.site/api/v1/thueso/create?tokenid=65170ce2bf4d11f4acfb99f45&quocgia=cam&dichvu=Google. Since this API does not require content, I can skip the content type section, but typically, APIs have content in the application/json format. Headers are often used to authenticate the account calling the API; in this case, I’ve included the API in the API address, so no additional information is needed.

After performing the query, the returned value will be in the following format:

{
    "code": 200,
    "data": {
        "amount": 850,
        "brand": "Google",
        "codeID": "65728afa50806207f8b22c6a",
        "phoneNumber": "855769145977"
    }
}

In the response section, since the requirement is to retrieve the received phone number along with the codeID to be used for OTP retrieval for this phone number, I will use the value of the data object. Therefore, I fill in the Data path field with the name of the object to retrieve the value bien.

Finally, to use the retrieved data object value, I choose to assign it to a variable with the option to assign that object value to any variable. Then, I can retrieve the value of codeID or phoneNumber using the expression {{variables.bien.codeID}} or {{variables.bien.phoneNumber}}.

• API to Get Code for the Rented Phone Number In the request method section, I use the GET method to retrieve the value. The Request URL is the provided API address to get the phone number; on this website, the address format is: http://ktool.site/api/v1/thueso/detail?tokenid={my token}&code={codeID from the phone number retrieval data}, I can adjust the options to complete the API address, for example: http://ktool.site/api/v1/thueso/detail?tokenid=65170ce2bf4d11f4acfb99f45&code={{variables.bien.codeID}}. Since this API does not require content, I can skip the content type section, but typically, APIs have content in the application/json format. Headers are often used to authenticate the account calling the API; in this case, I’ve included the API in the API address, so no additional information is needed.

After performing the query, the returned value will be in the following format:

{
    "code": 200,
    "data": {
        "status": true,
        "otp": "127535",
        "id": "653103d36d2de34c3fa569d4",
        "brand": "Google"
    }
}

In the response section, since the requirement is to retrieve the received phone number along with the codeID to be used for OTP retrieval for this phone number, I will use the value of the data object. Therefore, I fill in the Data path field with the name of the object to retrieve the value bien1.

Finally, to use the retrieved data object value, I choose to assign it to a variable with the option to assign that object value to any variable.

Then, I can retrieve the otp value to use in the Press Key node to fill in the code at the required position using the syntax {{variables.bien1.otp}}.

Insert Value into Google Sheet When Running a Profile

Example

Here, I want to open all the links retrieved from Google Sheets and then insert the done status in the stt column in the same row as that link’s value.

First, I will create a variable called range using the Insert Data node.

Next, configure the Google Sheets node to retrieve data from Google Sheets as follows:

Next, configure the Loop Data node to retrieve data from the Google Sheets node.

Next, configure the Open URL node to open the link in each loop using the template expression {{loopData.loopId.ten_cot_du_lieu}}, and in this script, it is {{loopData.sheet.link}}.

Next, I will configure the HTTP Request node to insert the status into the stt column. To configure the Request URL, I need to follow these steps first:

First, go to the link https://script.google.com/home and follow the steps as shown in the images:

At this point, I delete the existing value and paste this code:

function doPost(e) {
  try {
    const spreadsheetId = e.parameter.spreadsheetId;
    const range = e.parameter.range;
    const obj = JSON.parse(e.postData.contents);
    const values = obj;
    const valueInputOption = "USER_ENTERED";
    Sheets.Spreadsheets.Values.update({ values }, spreadsheetId, range, {valueInputOption: valueInputOption});
    return ContentService.createTextOutput("ok");
  } catch(e) {
    return ContentService.createTextOutput(JSON.stringify(e));
  }
}

function doGet(e) {
  return ContentService.createTextOutput("Success!");
}

Finally, copy this URL value:

Now, I will use this URL in the HTTP Request node as follows:

In the Request URL, I will fill in according to the formula URL?googlesheetId=a&range=b, where a is the ID of the Google Sheets where I want to insert the status, and b is the cell I want to update the value for. If there are multiple sheets like sheet1, sheet2, I can specify the range as range=sheet2!b. In this case, it would be written as: https://script.google.com/macros/s/AKfycbxw6yFtbqapqJ07J9gwyKUoGhXjc_kIehxT1HPO9ZUwCal-iw4SIjB53ahIs-WNEBXdtA/exec?spreadsheetId=1qDb4fe4dWFHfd1HIYkc8JPTd0IoYpsRVyTwfJhaZcV8&range=B{{variables.range}}.

Next, in the content section, I will fill in the text I want to insert as follows. If it’s a variable or a value from any expression, I can write it like this: [["{{variables.a}}"]] if I want to insert the value of variable a into the column.

In the Response section, I assign the response value to a variable status to determine whether the status has been inserted or not.

If the insertion is successful, the variable akan menerima nilai seperti berikut:

Next, use the Insert Data node to increment the range variable by 1 unit, so in the next loop, the inserted cell will be B3.

The code block will then look like this:

When running this code block, the done value will be updated next to each value in the link column.

Insert Value into Google Sheet When Running Multiple Profiles

Example

Here, I want the script to open a link retrieved from Google Sheets and then insert the done status in the stt column in the same row as that link’s value for each profile.

Next, configure the Google Sheets node to retrieve data from Google Sheets as follows:

Next, configure the Open URL node to open the link in each loop using the template expression {{googleSheets.khoa_tham_chieu.[runIndex].ten_cot}}, and in this script, it is {{googleSheets.data.[runIndex].link}}. runIndex here represents the profile order when running; for example, if two profiles run simultaneously, the first profile will have a runIndex value of 0, and the second profile will have a runIndex value of 1.

Next, I will configure the HTTP Request node to insert the status into the stt column. To configure the Request URL, I need to follow these steps first:

First, go to the link https://script.google.com/home and follow the steps as shown in the images:

At this point, I delete the existing value and paste this code:

function doPost(e) {
  try {
    const spreadsheetId = e.parameter.spreadsheetId;
    const range = e.parameter.range;
    const obj = JSON.parse(e.postData.contents);
    const values = obj;
    const valueInputOption = "USER_ENTERED";
    Sheets.Spreadsheets.Values.update({ values }, spreadsheetId, range, {valueInputOption: valueInputOption});
    return ContentService.createTextOutput("ok");
  } catch(e) {
    return ContentService.createTextOutput(JSON.stringify(e));
  }
}

function doGet(e) {
  return ContentService.createTextOutput("Success!");
}

Finally, copy this URL value:

Now, I will use this URL in the HTTP Request node as follows:

In the Request URL, I will fill in according to the formula URL?googlesheetId=a&range=b, where a is the ID of the Google Sheets where I want to insert the status, and b is the cell I want to update the value for. If there are multiple sheets like sheet1, sheet2, I can specify the range as range=sheet2!b. In this case, it would be written as: https://script.google.com/macros/s/AKfycbxw6yFtbqapqJ07J9gwyKUoGhXjc_kIehxT1HPO9ZUwCal-iw4SIjB53ahIs-WNEBXdtA/exec?spreadsheetId=1qDb4fe4dWFHfd1HIYkc8JPTd0IoYpsRVyTwfJhaZcV8&range=B{{$increment([runIndex],2)}}.

Next, in the content section, I will fill in the text I want to insert as follows. If it’s a variable or a value from any expression, I can write it like this: [["{{variables.a}}"]] if I want to insert the value of variable a into the column.

In the Response section, I assign the response value to a variable status to determine whether the status has been inserted or not.

If the insertion is successful, the variable will receive the value as follows:

The code block will then look like this:

When running this code block, the desired value will be updated next to each value in the link column.