Skip to content

Record

Provide manipulate functions on records: get, update, delete, update the record status & assignees in the kintone app

Constructor

Parameters

Name Type Required Description
params Object (conditional) Required for nodejs
Constructor params.
params.connection Connection (conditional) The connection module of this SDK.
If initializing in a browser environment on kintone, this parameter can be omitted to use session authentication.

Sample code

Init record module Javascript

  (function(kintoneJSSDK) {
      'use strict';
      // with connection
      // Define Authentication object
      var kintoneAuth = new kintoneJSSDK.Auth();
      var paramsAuth = {
          username: 'YOUR_USER_NAME',
          password: 'YOUR_PASSWORD'
      };
      kintoneAuth.setPasswordAuth(paramsAuth);

      var paramsConnection = {
          domain: 'YOUR_DOMAIN',
          auth: kintoneAuth
      };
      var connection = new kintoneJSSDK.Connection(paramsConnection);
      var kintoneRecord = new kintoneJSSDK.Record({connection});

      // without connection, module will use session authentication of kintone
      var kintoneRecord = new kintoneJSSDK.Record();
  }(window.kintoneJSSDK));

Nodejs

  const kintone = require('@kintone/kintone-js-sdk');

  const kintoneAuth = new kintone.Auth();
  const paramsAuth = {
      username: 'YOUR_USER_NAME',
      password: 'YOUR_PASSWORD'
  };
  kintoneAuth.setPasswordAuth(paramsAuth);

  const paramsConnection = {
      domain: 'YOUR_DOMAIN',
      auth: kintoneAuth
  };
  const connection = new kintone.Connection(paramsConnection);
  const kintoneRecord = new kintone.Record({connection});

Methods

getRecord(params)

Retrieves details of 1 record from an app.

Parameters

Name Type Required Description
params Object yes Get record params
params.app Integer yes The kintone app ID
params.id Integer yes The record ID in kintone app

Return

Promise

Sample code

Get record Javascript

  var app = YOUR_APP_ID;
  var id = YOUR_RECORD_ID;
  kintoneRecord.getRecord({app, id}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const id = YOUR_RECORD_ID;
  kintoneRecord.getRecord({app, id}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

getRecords(params)

Retrieves details of multiple records from an app using a query string.

Parameters

Name Type Required Description
params Object yes Get records params
params.app Integer yes The kintone app ID
params.query String (optional) The query string that will specify what records will be responded.
params.fields Array<String> (optional) List of field codes you want in the response.
params.totalCount Boolean (optional) If "true", the request will retrieve the total count of records match with query conditions.

Return

Promise

Sample code

Get records Javascript

  var app = YOUR_APP_ID;
  var query = 'YOUR_QUERY_STRING';
  var fields = [
      'YOUR_FIELD_CODE',
      // another fieldCode
  ]
  var totalCount = 'YOUR_DECIDE_TRUE_OR_FALSE';
  kintoneRecord.getRecords({app, query, fields, totalCount}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const query = 'YOUR_QUERY_STRING';
  const fields = [
      'YOUR_FIELD_CODE',
      // another fieldCode
  ]
  const totalCount = 'YOUR_DECIDE_TRUE_OR_FALSE';
  kintoneRecord.getRecords({app, query, fields, totalCount}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

getAllRecordsByQuery(params)

  • Retrieves details of all records from an app using a query string.
  • Number of records can be retrieved at once is greater than the default limitations

Parameters

Name Type Required Description
params Object yes Get records by query params
params.app Integer yes The kintone app ID
params.query String (optional) The query string that will specify what records will be responded.
params.fields Array<String> (optional) List of field codes you want in the response.
params.totalCount Boolean (optional) If "true", the request will retrieve the total count of records match with query conditions.
params.seek Boolean (optional) Default value is "false".
・false:using offset method
You can get all records within the limits of offset.(※Around July 2020, cybozu plan to set an offset upper limit of 10,000)
You can not specify "offset" and "limit" clause on the query when you use offset method because these clauses are already used internally.

・true:using seek method
You get all records(over limitation of offset) in order by record ID.
But you can not specify "order by", "offset" and "limit" clause on the query when you use seek method because these clauses are already used internally.

usage about offset and seek method

・usage about offset method and seek method(ja)
・info about offset method(us)
・info about seek method(us)

Return

Promise

Sample code

Get all records by the query without limitation Javascript

  var app = YOUR_APP_ID;
  var query = 'YOUR_QUERY_STRING';
  var fields = [
      'YOUR_FIELD_CODE',
      // another fieldCode
  ]
  var totalCount = 'YOUR_DECIDE_TRUE_OR_FALSE';
  var seek = 'YOUR_DECIDE_TRUE_OR_FALSE';
  kintoneRecord.getAllRecordsByQuery({app, query, fields, totalCount, seek}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const query = 'YOUR_QUERY_STRING';
  const fields = [
      'YOUR_FIELD_CODE',
      // another fieldCode
  ]
  const totalCount = 'YOUR_DECIDE_TRUE_OR_FALSE';
  const seek = 'YOUR_DECIDE_TRUE_OR_FALSE';
  kintoneRecord.getAllRecordsByQuery({app, query, fields, totalCount, seek}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

getAllRecordsByCursor(params)

  • Retrieves details of all records from an app using a query string.
  • Can't indicate limit and offset of the query.
  • Number of records can be retrieved at once is greater than the default limitations

Parameters

Name Type Required Description
params Object yes Params to get all record by cursor
params.app Integer yes The kintone app ID
params.query String (optional) The query string that will specify what records will be responded.
option.fields Array<String> (optional) List of field codes you want in the response.

Return

Promise

Sample code

Get all records by cursor Javascript
  var rcOption = {
    app: YOUR_APP_ID,
    fields: [
      'YOUR_FIELD_CODE',
      // another fieldCode
    ],
    query: 'YOUR_QUERY_STRING'
  };

  kintoneRecord.getAllRecordsByCursor(rcOption).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const rcOption = {
    app: YOUR_APP_ID,
    fields: [
      'YOUR_FIELD_CODE',
      // another fieldCode
    ],
    query: 'YOUR_QUERY_STRING'
  };

  kintoneRecord.getAllRecordsByCursor(rcOption).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

addRecord(params)

Add one record to an app.

Parameters

Name Type Required Description
params Object yes Params to add record
params.app Integer yes The kintone app ID
params.record JSONObject (optional) The record data to be added to kintone app. About the format, please look at the sample below or reference at the end of this page

Return

Promise

Sample code

Add record Javascript

  var app = YOUR_APP_ID;
  var record = {
    YOUR_FIELD_CODE: {
      value: 'VALUE_OF_YOUR_FIELD_CODE'
    },
    // Another fieldcode here
  };
  kintoneRecord.addRecord({app, record}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const record = {
      YOUR_FIELD_CODE: {
          value: 'VALUE_OF_YOUR_FIELD_CODE'
      },
      // Another fieldcode here
  };
  kintoneRecord.addRecord({app, record}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

addRecords(params)

Add multiple records to an app.

Parameters

Name Type Required Description
params Object yes Params to add records
params.app Integer yes The kintone app ID
params.records Array<JSONObject> yes List of records data to be added to kintone app. About the format, please look at the sample below or reference at the end of this page.

Return

Promise

Sample code

Add multiple records Javascript

  var app = YOUR_APP_ID;
  var record = {
      YOUR_FIELD_CODE: {
          value: 'VALUE_OF_YOUR_FIELD_CODE'
      },
      // Another fieldcode here
  };
  var records = [
      record,
      // another record
  ];
  kintoneRecord.addRecords({app, records}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const record = {
    YOUR_FIELD_CODE: {
      value: 'VALUE_OF_YOUR_FIELD_CODE'
    },
    // Another fieldcode here
  };
  const records = [
    record
    // another record
  ];
  kintoneRecord.addRecords({app, records}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

addAllRecords(params)

  • Add multiple records to an app.
  • Can insert over 2000 records to kintone app, but can't do the rollback.

Parameters

Name Type Required Description
params Object yes Params to add all record
params.app Integer yes The kintone app ID
params.records Array<JSONObject> yes List of records data to be added to kintone app. About the format, please look at the sample below or reference at the end of this page.

Return

Promise

Sample code

Add all records without limitation Javascript

  var app = YOUR_APP_ID;
  var record = {
      YOUR_FIELD_CODE: {
          value: 'VALUE_OF_YOUR_FIELD_CODE'
      },
      // Another fieldcode here
  };
  var records = [
      record,
      // another record
  ];
  kintoneRecord.addAllRecords({app, records}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // Ex: User update 6000 records: 
    // Case 1: the error occurs in record 0
    // err response
    // {
    //   results: [KintoneAPIException, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {},{}]
    // }
    // Case 2: the error occurs in record 4000
    // err response
    // {
    //   results: [
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    KintoneAPIException,
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {}
    //  ]
    // }
    console.log(err)
  });

Nodejs

  const app = YOUR_APP_ID;
  const record = {
    YOUR_FIELD_CODE: {
      value: 'VALUE_OF_YOUR_FIELD_CODE'
    },
    // Another fieldcode here
  };
  const records = [
    record
    // another record
  ];
  kintoneRecord.addAllRecords({app, records}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // Ex: User update 6000 records: 
    // Case 1: the error occurs in record 0
    // err response
    // {
    //   results: [KintoneAPIException, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {},{}]
    // }
    // Case 2: the error occurs in record 4000
    // err response
    // {
    //   results: [
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    AddRecordsResponse,
    //    KintoneAPIException,
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {}
    //  ]
    // }
    console.log(err)
  });

updateRecordByID(params)

Updates details of 1 record in an app by specifying its record number.

Parameters

Name Type Required Description
params Object yes Params to update record by id
params.app Integer yes The kintone app ID
params.id Integer yes The record ID on kintone app
params.record JSONObject (optional) The record data to be updated in kintone app. About the format, please look at the sample below or reference at the end of this page.
params.revision Integer (optional) The revision number of record

Return

Promise

Sample code

Update record by ID Javascript

  var app = YOUR_APP_ID;
  var id = YOUR_RECORD_ID;
  var record = {
      YOUR_FIELD_CODE: {
          value: 'VALUE_OF_YOUR_FIELD_CODE'
      },
      // Another fieldcode here
  };
  var revision = REVISION_OF_RECORD;
  kintoneRecord.updateRecordByID({app, id, record, revision}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const id = YOUR_RECORD_ID;
  const record = {
    YOUR_FIELD_CODE: {
      value: 'VALUE_OF_YOUR_FIELD_CODE'
    },
    // Another fieldcode here
  };
  const revision = REVISION_OF_RECORD;
  kintoneRecord.updateRecordByID({app, id, record, revision}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

updateRecordByUpdateKey(params)

Updates details of 1 record in an app by a unique key.

Parameters

Name Type Required Description
params Object yes Params to update record by update key
params.app Integer yes The kintone app ID
params.updateKey JSONObject yes The unique key of the record to be updated. About the format, please look at the sample below or reference at the end of this page.
params.record JSONObject (optional) The record data will be updated to kintone app. About the format, please look at the sample below or reference at the end of this page.
params.revision Integer (optional) The revision number of record

Return

Promise

Sample code

Update record by UpdateKey Javascript

  var app = YOUR_APP_ID;
  var updateKey = {
    field: 'YOUR_FIELD_CODE',
    value: 'YOUR_FIELD_CODE_VALUE'
  };
  var record = {
    YOUR_FIELD_CODE: {
      value: 'VALUE_OF_YOUR_FIELD_CODE'
    },
    // Another fieldcode here
  };
  var revision = REVISION_OF_RECORD;
  kintoneRecord.updateRecordByUpdateKey({app, updateKey, record, revision}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const updateKey = {
    field: 'YOUR_FIELD_CODE',
    value: 'YOUR_FIELD_CODE_VALUE'
  };
  const record = {
    YOUR_FIELD_CODE: {
      value: 'VALUE_OF_YOUR_FIELD_CODE'
    },
    // Another fieldcode here
  };
  const revision = REVISION_OF_RECORD;
  kintoneRecord.updateRecordByUpdateKey({app, updateKey, record, revision}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

updateRecords(params)

Updates details of multiple records in an app, by specifying their record number, or a different unique key.

Parameters

Name Type Required Description
params Object yes Params to update records
params.app Integer yes The kintone app ID
params.records Array<JSONObject> (optional) The record data will be updated to kintone app. About the format, please look at the sample below or reference at the end of this page.

Return

Promise

Sample code

Update multiple records Javascript

  var app = YOUR_APP_ID;
  var record = {
    YOUR_FIELD_CODE: {
      value: 'VALUE_OF_YOUR_FIELD_CODE'
    },
    // Another fieldcode here
  };

  // This object can not have both "id" and "updateKey" keys at the same time.
  var recordUpdate = {
    // Required, if updateKey will not be specified.
    id: YOUR_RECORD_ID, 
    // Required, if id will not be specified.
    updateKey: { 
      field: 'YOUR_FIELD_CODE',
      value: 'YOUR_FIELD_CODE_VALUE'
    },
    record: record,
    revision: RECORD_REVISION_NUMBER
  };
  var records= [
    recordUpdate,
    // Another recordUpdate
  ]
  kintoneRecord.updateRecords({app, records}).then((rsp) => {
      console.log(rsp);
    }).catch((err) => {
      // This SDK return err with KintoneAPIException
      console.log(err);
    });

Nodejs

  const app = YOUR_APP_ID;
  const record = {
      YOUR_FIELD_CODE: {
          value: 'VALUE_OF_YOUR_FIELD_CODE'
      },
      // Another fieldcode here
  };

  // This object can not have both "id" and "updateKey" keys at the same time.
  const recordUpdate = {
      // Required, if updateKey will not be specified.
      id: YOUR_RECORD_ID, 
      // Required, if id will not be specified.
      updateKey: { 
          field: 'YOUR_FIELD_CODE',
          value: 'YOUR_FIELD_CODE_VALUE'
      },
      record: record,
      revision: RECORD_REVISION_NUMBER
  };
  const records = [
      recordUpdate,
      // Another recordUpdate
  ]
  kintoneRecord.updateRecords({app, records}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

updateAllRecords(params)

  • Updates details of multiple records in an app, by specifying their record number, or a different unique key.
  • Can update over 2000 records to kintone app, but can't do the rollback.

Parameters

Name Type Required Description
params Object yes Params to update all records
params.app Integer yes The kintone app ID
params.records Array<JSONObject> yes The record data will be updated to kintone app. About the format, please look at the sample below or reference at the end of this page.

Return

Promise

Sample code

Update all records without limitation Javascript

  var app = YOUR_APP_ID;
  var record = {
    YOUR_FIELD_CODE: {
      value: 'VALUE_OF_YOUR_FIELD_CODE'
    },
    // Another fieldcode here
  };

  // This object can not have both "id" and "updateKey" keys at the same time.
  var recordUpdate = {
    // Required, if updateKey will not be specified.
    id: YOUR_RECORD_ID, 
    // Required, if id will not be specified.
    updateKey: { 
      field: 'YOUR_FIELD_CODE',
      value: 'YOUR_FIELD_CODE_VALUE'
    },
    record: record,
    revision: RECORD_REVISION_NUMBER
  };
  var records = [
    recordUpdate,
    // Another recordUpdate
  ]
  kintoneRecord.updateAllRecords({app, records}).then((rsp) => {
      console.log(rsp);
    }).catch((err) => {
      // Ex: User update 6000 records: 
    // Case 1: the error occurs in record 0
    // err response
    // {
    //   results: [KintoneAPIException, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {},{}]
    // }
    // Case 2: the error occurs in record 4000
    // err response
    // {
    //   results: [
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    KintoneAPIException,
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {}
    //  ]
    // }
    console.log(err)
    });

Nodejs

  const app = YOUR_APP_ID;
  const record = {
      YOUR_FIELD_CODE: {
          value: 'VALUE_OF_YOUR_FIELD_CODE'
      },
      // Another fieldcode here
  };

  // This object can not have both "id" and "updateKey" keys at the same time.
  const recordUpdate = {
      // Required, if updateKey will not be specified.
      id: YOUR_RECORD_ID, 
      // Required, if id will not be specified.
      updateKey: { 
          field: 'YOUR_FIELD_CODE',
          value: 'YOUR_FIELD_CODE_VALUE'
      },
      record: record,
      revision: RECORD_REVISION_NUMBER
  };
  const records = [
      recordUpdate,
      // Another recordUpdate
  ]
  kintoneRecord.updateAllRecords({app, records}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // Ex: User update 6000 records: 
    // Case 1: the error occurs in record 0
    // err response
    // {
    //   results: [KintoneAPIException, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {},{}]
    // }
    // Case 2: the error occurs in record 4000
    // err response
    // {
    //   results: [
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    UpdateRecordsResponse,
    //    KintoneAPIException,
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {}
    //  ]
    // }
    console.log(err)
  });

deleteRecords(params)

Delete multiple records in an app.

Parameters

Name Type Required Description
params Object yes Params to delete records
params.app Integer yes The kintone app ID
params.ids Array<Integer> yes The list ids of record will be delete.

Return

None

Sample code

Delete multi record Javascript

  var app = YOUR_APP_ID;
  var ids = [YOUR_RECORD_ID]
  kintoneRecord.deleteRecords({app, ids}).then((rsp) => {
      console.log(rsp);
    }).catch((err) => {
      // This SDK return err with KintoneAPIException
      console.log(err);
    });

Nodejs

  const app = YOUR_APP_ID;
  const ids = [YOUR_RECORD_ID]
  kintoneRecord.deleteRecords({app, ids}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

deleteRecordsWithRevision(params)

Delete multiple records in an app with revision.

Parameters

Name Type Required Description
params Object yes Params to delete record with revision
params.app Integer yes The kintone app ID
params.idsWithRevision JSONObject yes JSONObject format by HashTable<Integer, Integer> (key: The Id of record, value: The Revision of record.)

Return

None

Sample code

Delete record with revision Javascript

  var app = YOUR_APP_ID;
  var idsWithRevision = {
    YOUR_RECORD_ID: REVISION_OF_RECORD
  }
  kintoneRecord.deleteRecordsWithRevision({app, idsWithRevision}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const idsWithRevision = {
      YOUR_RECORD_ID: REVISION_OF_RECORD
  }
  kintoneRecord.deleteRecordsWithRevision({app, idsWithRevision}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

deleteAllRecordsByQuery(params)

  • Deletes all records in an app by query string
  • Can delete over 2000 records, but can't do the rollback.

Parameters

Name Type Required Description
params Object yes Delete all records by query
params.app Integer yes The kintone app ID
params.query String (optional) The query string that will specify what records will be responded.
The query parameter can't indicate limit and offset.

Return

Promise

Sample code

Delete all records by query string Javascript

  var app = YOUR_APP_ID;
  var query = 'YOUR_QUERY_STRING';
  kintoneRecord.deleteAllRecordsByQuery({app, query}).then((rsp) => {
      console.log(rsp);
  })
  .catch((err) => {
      // Ex: User update 6000 records: 
    // Case 1: the error occurs in record 0
    // err response
    // {
    //   results: [KintoneAPIException, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {},{}]
    // }
    // Case 2: the error occurs in record 4000
    // err response
    // {
    //   results: [
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    KintoneAPIException,
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {}
    //  ]
    // }
    console.log(err)
  });

Nodejs

  const app = YOUR_APP_ID;
  const query = 'YOUR_QUERY_STRING';
  kintoneRecord.deleteAllRecordsByQuery({app, query}).then((rsp) => {
      console.log(rsp);
  })
  .catch((err) => {
    // Ex: User update 6000 records: 
    // Case 1: the error occurs in record 0
    // err response
    // {
    //   results: [KintoneAPIException, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {},{}]
    // }
    // Case 2: the error occurs in record 4000
    // err response
    // {
    //   results: [
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    RecordsResponseDelete,
    //    KintoneAPIException,
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {},
    //    {}
    //  ]
    // }
    console.log(err)
  });

upsertRecord(params)

  • Insert or update a record to kintone app.
  • Insert the record if the updateKey doesn't exist and update the record if the updateKey exists.

Parameters

Name Type Required Description
params Object yes Params to upsert record
params.app Integer yes The kintone app ID
params.updateKey JSONObject yes The unique key of the record to be updated. About the format, please look at the sample below or reference at the end of this page.
params.record JSONObject yes The record data will be added to kintone app. About the format, please look at the sample below or reference at the end of this page.
params.revision Integer (optional) The revision number of record

Return

Promise

Sample code

Upsert record by UpdateKey Javascript

  var app = YOUR_APP_ID;
  var updateKey = {
    field: 'YOUR_FIELD_CODE',
    value: 'YOUR_FIELD_CODE_VALUE'
  };
  var record = {
    YOUR_FIELD_CODE: {
      value: 'VALUE_OF_YOUR_FIELD_CODE'
    },
    // Another fieldcode here
  };
  var revision = REVISION_OF_RECORD;
  kintoneRecord.upsertRecord({app, updateKey, record, revision}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const updateKey = {
    field: 'YOUR_FIELD_CODE',
    value: 'YOUR_FIELD_CODE_VALUE'
  };
  const record = {
    YOUR_FIELD_CODE: {
      value: 'VALUE_OF_YOUR_FIELD_CODE'
    },
    // Another fieldcode here
  };
  const revision = REVISION_OF_RECORD;
  kintoneRecord.upsertRecord({app, updateKey, record, revision}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

upsertRecords(params)

  • Insert or update up to 1500 records to kintone app.
  • If the records are over 1500, It is thrown Error.
  • Insert the records if the updateKey doesn't exist and update the records if the updateKey exists.

Parameters

Name Type Required Description
params Object yes Params to upsert records
params.app Integer yes The kintone app ID
params.records Array<JSONObject> yes The record data Array which has updateKey and record. About the format, please look at the sample below or reference at the end of this page.

Return

Promise

Sample code

Upsert records by UpdateKey Javascript

  var app = YOUR_APP_ID;
  var records = [
    {
      updateKey: {
        field: 'YOUR_FIELD_CODE',
        value: 'YOUR_FIELD_CODE_VALUE_1'
      },
      record: {
        YOUR_FIELD_CODE: {
          value: 'VALUE_OF_YOUR_FIELD_CODE 1'
        },
      }
    },
    {
      updateKey: {
        field: 'YOUR_FIELD_CODE',
        value: 'YOUR_FIELD_CODE_VALUE_2'
      },
      record: {
        YOUR_FIELD_CODE: {
          value: 'VALUE_OF_YOUR_FIELD_CODE 2'
        },
      }
    },
    {
      updateKey: {
        field: 'YOUR_FIELD_CODE',
        value: 'YOUR_FIELD_CODE_VALUE_3'
      },
      record: {
        YOUR_FIELD_CODE: {
          value: 'VALUE_OF_YOUR_FIELD_CODE 3'
        },
      }
    }
  ];
  kintoneRecord.upsertRecords({app, records}).then((resp) => {
    console.log(resp);
  }).catch((err) => {
    /// Ex: User upsert over 100 records: 
    // Case 1: the error occurs on a first record
    // err response
    // {
    //   results: [KintoneAPIException, {},...]
    // }
    // Case 2: the error occurs on the 100th or more record 
    // err response
    // {
    //   results: [{},..., KintoneAPIException, {},...]
    // }
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const records = [
    {
      updateKey: {
        field: 'YOUR_FIELD_CODE',
        value: 'YOUR_FIELD_CODE_VALUE_1'
      },
      record: {
        YOUR_FIELD_CODE: {
          value: 'VALUE_OF_YOUR_FIELD_CODE 1'
        },
      }
    },
    {
      updateKey: {
        field: 'YOUR_FIELD_CODE',
        value: 'YOUR_FIELD_CODE_VALUE_2'
      },
      record: {
        YOUR_FIELD_CODE: {
          value: 'VALUE_OF_YOUR_FIELD_CODE 2'
        },
      }
    },
    {
      updateKey: {
        field: 'YOUR_FIELD_CODE',
        value: 'YOUR_FIELD_CODE_VALUE_3'
      },
      record: {
        YOUR_FIELD_CODE: {
          value: 'VALUE_OF_YOUR_FIELD_CODE 3'
        },
      }
    }
  ];
  kintoneRecord.upsertRecords({app, records}).then((resp) => {
    console.log(resp);
  }).catch((err) => {
    /// Ex: User upsert over 100 records: 
    // Case 1: the error occurs on a first record
    // err response
    // {
    //   results: [KintoneAPIException, {},...]
    // }
    // Case 2: the error occurs on the 100th or more record 
    // err response
    // {
    //   results: [{},..., KintoneAPIException, {},...]
    // }
    console.log(err);
  });

updateRecordAssignees(params)

Update assignees of a record.

Parameters

Name Type Required Description
params Object yes Params to update record assignees
params.app Integer yes The kintone app ID
params.id Integer yes The record ID of kintone app
params.assignees Array<String> yes The user codes of the assignees
params.revision Integer (optional) The revision number of record

Return

Promise

Sample code

update record Assignees Javascript

  var app = YOUR_APP_ID;
  var id = YOUR_RECORD_ID;
  var assignees = ['YOUR_ASSIGNEE'];
  var revision = REVISION_OF_RECORD;

  kintoneRecord.updateRecordAssignees({app, id, assignees, revision}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const id = YOUR_RECORD_ID;
  const assignees = ['YOUR_ASSIGNEE'];
  const revision = REVISION_OF_RECORD;

  kintoneRecord.updateRecordAssignees({app, id, assignees, revision}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

updateRecordStatus(params)

Updates the Status of a record of an app.

Parameters

Name Type Required Description
params Object yes Params to update record status
params.app Integer yes The kintone app ID.
params.id Integer yes The record ID on kintone app.
params.action String yes The Action name will be run.
params.assignee String (conditional) The next Assignee. Specify the Assignee's login name.
Required, if the "Assignee List" of the current status is set to "User chooses one assignee from the list to take action", and a selectable assignee exists.
params.revision Integer (optional) The revision of record

Return

Promise

Sample code

Update record status Javascript

  var app = YOUR_APP_ID;
  var id = YOUR_RECORD_ID;
  var action = 'YOUR_ACTION_NAME';
  var assignee = 'YOUR_ASSIGNEE';
  var revision = REVISION_OF_RECORD;

  kintoneRecord.updateRecordStatus({app, id, action, assignee, revision}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const id = YOUR_RECORD_ID;
  const action = YOUR_ACTION_NAME;
  const assignee = 'YOUR_ASSIGNEE';
  const revision = REVISION_OF_RECORD;

  kintoneRecord.updateRecordStatus({app, id, action, assignee, revision}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

updateRecordsStatus(params)

Updates the Status of multiple records of an app.

Parameters

Name Type Required Description
params Object yes Params to update records status
params.app Integer yes The kintone app ID
params.records Array<JSONObject> yes The record status data. See the below sample codes and reference at the end of this page to know the format.

Return

Promise

Sample code

Update status of multiple records Javascript

  var app = YOUR_APP_ID;
  var recordStatusUpdateItem = {
    id: YOUR_RECORD_ID,
    action: 'YOUR_ACTION_NAME',
    assignee: 'YOUR_ASSIGNEE',
    revision: 'YOUR_RECORD_REVISION'
  }
  var records = [
    recordStatusUpdateItem,
    // another data like recordStatusUpdateItem
  ];
  kintoneRecord.updateRecordsStatus({app, records}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const recordStatusUpdateItem = {
      id: YOUR_RECORD_ID,
      action: 'YOUR_ACTION_NAME',
      assignee: 'YOUR_ASSIGNEE',
      revision: YOUR_RECORD_REVISION
  }
  const records = [
      recordStatusUpdateItem,
      //another data like recordStatusUpdateItem
  ];
  kintoneRecord.updateRecordsStatus({app, records}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

getComments(params)

Retrieves multiple comments from a record in an app.

Parameters

Name Type Required Description
params Object yes Params to get comments
params.app Integer yes The kintone app ID
params.record Integer yes The ID of record
params.order String (optional) The sort order of the Comment ID. Please select asc or desc
params.offset Integer (optional) The number of first comments will be ignored.
params.limit Integer (optional) The number of records to retrieve.

Return

Promise

Sample code

Get comments Javascript

  var app = YOUR_APP_ID;
  var record = YOUR_RECORD_ID;
  var order = 'YOUR_ORDER_TYPE'; // asc or desc
  var offset = YOUR_OFFSET_NUMBER;
  var limit = YOUR_LIMIT_NUMBER;
  kintoneRecord.getComments({app, record, order, offset, limit}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const record = YOUR_RECORD_ID;
  const order = 'YOUR_ORDER_TYPE'; // asc or desc
  const offset = YOUR_OFFSET_NUMBER;
  const limit = YOUR_LIMIT_NUMBER;
  kintoneRecord.getComments({app, record, order, offset, limit}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

addComment(params)

Add a comment to a record in an app.

Parameters

Name Type Required Description
params Object yes Params to add comment
params.app Integer yes The kintone app ID
params.record Integer yes The ID of record
params.comment JSONObject yes About the format, please look at the sample below or reference at the end of this page.

Return

Promise

Sample code

Add comment Javascript

  var app = YOUR_APP_ID;
  var record = YOUR_RECORD_ID;
  var comment = {
    text: 'YOUR_COMMENT_CONTENT',
    mentions: [
      {
        code: 'YOUR_MEMBER_CODE',
        type: 'YOUR_MEMBER_TYPE' // either `USER` or `GROUP` or `ORGANIZATION`
      },
      // another mention here
    ]
  };
  kintoneRecord.addComment({app, record, comment}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const record = YOUR_RECORD_ID;
  const comment = {
    text: 'YOUR_COMMENT_CONTENT',
    mentions: [
      {
        code: 'YOUR_MEMBER_CODE',
        type: 'YOUR_MEMBER_TYPE' // either `USER` or `GROUP` or `ORGANIZATION`
      },
      // another mention here
    ]
  };
  kintoneRecord.addComment({app, record, comment}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

deleteComment(params)

Delete a comment in a record in an app.

Parameters

Name Type Required Description
params Object yes Params to delete comment
params.app Integer yes The kintone app ID
params.record Integer yes The record ID on kintone app
params.comment Integer yes The comment ID on kintone record

Return

Promise

Sample code

Delete comment Javascript

  var app = YOUR_APP_ID;
  var record = YOUR_RECORD_ID;
  var comment = YOUR_COMMENT_ID;
  kintoneRecord.deleteComment({app, record, comment}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Nodejs

  const app = YOUR_APP_ID;
  const record = YOUR_RECORD_ID;
  const comment = YOUR_COMMENT_ID;
  kintoneRecord.deleteComment({app, record, comment}).then((rsp) => {
    console.log(rsp);
  }).catch((err) => {
    // This SDK return err with KintoneAPIException
    console.log(err);
  });

Reference