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	Required	Description
company_name	string	Yes	Name of the company for which the user is logging in
datasource_name	string	Yes	Name of the datasource
id	string	Yes	ID of record to be updated
data	string (JSON)	Yes	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 "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

url = "URL/access/klearstack/update_datasource_row"

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"
  }'}
files=[

]
headers = {
  'Authorization': 'Bearer your_token_here'
}

response = requests.request("POST", url, headers=headers, data=payload, files=files)

print(response.text)

Java (OkHttp)

• Request Body

OkHttpClient client = new OkHttpClient().newBuilder()
  .build();
MediaType mediaType = MediaType.parse("text/plain");
RequestBody body = new MultipartBody.Builder().setType(MultipartBody.FORM)
  .addFormDataPart("company_name", "Replace_Your_Company_Name_Here")
  .addFormDataPart("datasource_name", "Replace_Your_Datasource_Name_Here")
  .addFormDataPart("id", "Replace_Your_Record_ID_Here")
  .addFormDataPart("data", "{\n" +
    "    \"USER_FIRST_NAME\": \"Replace_FirstName\",\n" +
    "    \"USER_LAST_NAME\": \"Replace_LastName\"\n" +
    "  }")
  .build();
Request request = new Request.Builder()
  .url("URL/access/klearstack/update_datasource_row")
  .method("POST", body)
  .addHeader("Authorization", "Bearer Replace_Your_Token_Here")
  .build();
Response response = client.newCall(request).execute();

Node.js (Axios)

• Request Body

const axios = require('axios');
const FormData = require('form-data');

let formData = new FormData();
formData.append('company_name', 'Replace_Your_Company_Name_Here');
formData.append('datasource_name', 'Replace_Your_Datasource_Name_Here');
formData.append('id', 'Replace_Your_Record_ID_Here');
formData.append('data', '{\r\n    "USER_FIRST_NAME": "Replace_FirstName",\r\n    "USER_LAST_NAME": "Replace_LastName"\r\n  }');

let config = {
  method: 'post',
  maxBodyLength: Infinity,
  url: 'URL/access/klearstack/update_datasource_row',
  headers: { 
    'Authorization': 'Bearer Replace_Your_Token_Here', 
    ...formData.getHeaders()
  },
  data: formData
};

axios.request(config)
  .then((response) => {
    console.log(JSON.stringify(response.data));
  })
  .catch((error) => {
    console.log(error);
  });

JavaScript (XHR)

• Request Body

// WARNING: For POST requests, body is set to null by browsers.

var formData = new FormData();
formData.append("company_name", "Replace_Your_Company_Name_Here");
formData.append("datasource_name", "Replace_Your_Datasource_Name_Here");
formData.append("id", "Replace_Your_Record_ID_Here");
formData.append("data", "{\r\n    \"USER_FIRST_NAME\": \"Replace_FirstName\",\r\n    \"USER_LAST_NAME\": \"Replace_LastName\"\r\n  }");

var xhr = new XMLHttpRequest();
xhr.withCredentials = true;

xhr.addEventListener("readystatechange", function() {
  if(this.readyState === 4) {
    console.log(this.responseText);
  }
});

xhr.open("POST", "URL/access/klearstack/update_datasource_row");
xhr.setRequestHeader("Authorization", "Bearer Replace_Your_Token_Here");

xhr.send(formData);

API Response

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