Update Record of a Datasource

Endpoint Name: update_datasource_row

Request type : POST

Authorization: Bearer token as header

Endpoint Details: The update_datasource_row endpoint will be used to update a record in datasource.

Method	URL
POST	URL/access/klearstack/update_datasource_row

Request Body

Params	Values	Description
company_name	string	Name of the company for which the user is logging in
datasource_name	string	Name of the datasource
id	string	ID of record to be updated
data	string (JSON)	A valid JSON string that contains info that needs to be updated Example : {"USER_FIRST_NAE": "Marti", "USER_LAST_NAME": "URIB"}

Shell (cURL)

• Request Body

curl --location POST "URL/access/klearstack/update_datasource_row" \
  --header "Authorization: Bearer your_token_here" \
  --form "company_name=Replace_Company_Name_Here" \
  --form "datasource_name=Replace_Datasource_Name_Here" \
  --form "id=Replace_Record_ID_Here" \
  --form 'data={
    "USER_FIRST_NAME": "Marti",
    "USER_LAST_NAME": "URIB"
  }'

Python

• Request Body

import requests

# API URL
url = "URL/access/klearstack/update_datasource_row"

# Request payload
data = {
    "company_name": "Replace_Company_Name_Here",
    "datasource_name": "Replace_Datasource_Name_Here",
    "id": "Replace_Record_ID_Here",
    "data": {
        "USER_FIRST_NAME": "Marti",
        "USER_LAST_NAME": "URIB"
    }
}

# Headers
headers = {
    "Content-Type": "application/json",
    "Authorization": "Bearer your_token_here"
}

# Make the POST request
response = requests.post(url, json=data, headers=headers)

# Print the response
if response.status_code == 200:
    print(response.json())
else:
    print("Error:", response.text)

Java

• Request Body

import okhttp3.*;

import java.io.IOException;

public class UpdateDatasourceRowAPI {
    public static void main(String[] args) {
        OkHttpClient client = new OkHttpClient();

        // JSON payload
        String jsonPayload = "{ \"company_name\": \"Replace_Company_Name_Here\", " +
                "\"datasource_name\": \"Replace_Datasource_Name_Here\", " +
                "\"id\": \"Replace_Record_ID_Here\", " +
                "\"data\": { \"USER_FIRST_NAME\": \"Marti\", \"USER_LAST_NAME\": \"URIB\" } }";

        RequestBody body = RequestBody.create(
            jsonPayload, MediaType.parse("application/json"));

        Request request = new Request.Builder()
            .url("URL/access/klearstack/update_datasource_row")
            .post(body)
            .addHeader("Content-Type", "application/json")
            .addHeader("Authorization", "Bearer your_token_here")
            .build();

        try (Response response = client.newCall(request).execute()) {
            if (response.isSuccessful()) {
                System.out.println("Response: " + response.body().string());
            } else {
                System.out.println("Error: " + response.body().string());
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

Node.js

• Request Body

var request = require('request');

const payload = {
  "company_name": "Replace_Company_Name_Here",
  "datasource_name": "Replace_Datasource_Name_Here",
  "id": "Replace_Record_ID_Here",
  "data": {
    "USER_FIRST_NAME": "Marti",
    "USER_LAST_NAME": "URIB"
  }
};

const options = {
  url: 'URL/access/klearstack/update_datasource_row',
  headers: {
    'Content-Type': 'application/json',
    'Authorization': 'Bearer your_token_here'
  },
  json: payload
};

request.post(options, function(err, httpResponse, body) {
  if (err) {
    console.error('Request failed:', err);
    return;
  }

  console.log('Response:', body);
});

JavaScript (XMLHttpRequest)

• Request Body

var payload = JSON.stringify({
    company_name: "Replace_Company_Name_Here",
    datasource_name: "Replace_Datasource_Name_Here",
    id: "Replace_Record_ID_Here",
    data: {
        "USER_FIRST_NAME": "Marti",
        "USER_LAST_NAME": "URIB"
    }
});

var xhr = new XMLHttpRequest();
xhr.open("POST", "URL/access/klearstack/update_datasource_row", true);
xhr.setRequestHeader("Content-Type", "application/json");
xhr.setRequestHeader("Authorization", "Bearer your_token_here");

// Handle response
xhr.onreadystatechange = function () {
    if (xhr.readyState === XMLHttpRequest.DONE) {
        if (xhr.status === 200) {
            console.log("Response:", xhr.responseText);
        } else {
            console.error("Error:", xhr.responseText);
        }
    }
};

xhr.send(payload);

API Response

Status code	Example Response
200	{ "success": "Document updated successfully.", “release_version”:”7.8.9” }
400	{ "error": "Invalid key: USER_FIRST_NAE" }