Specify Record List via Query String

Contents

Overview

Look through the Get Records GET (/records.json) section to see the list of queries that can be used. URL encode the query with UTF-8.

Sample 1: Specifying a View list with a URL

1
https://{sub-domain}.kintone.com/k/{appId}/?view={viewId}

When you create a new view in the App settings, you will find the view ID in the URL of the view page.

Sample 2: Specifying a filtered list with a URL

1
https://{sub-domain}.kintone.com/k/{appId}/?query={UTF-8 encoded query}

Sample

Say that we are looking for records where the Single-line text field is “kintone”, and the Radio Button field is “A”. Consider an app with the following properties:

  • Sub domain: example
  • App ID: 123
  • Field code of the Single-line text field: text_field
  • Field code of the Radio Button field: choice_field

The query for this would be:

1
text_field="kintone" and choice_field in ("A")

URL encode this, and place it as the value for the query, as below:

1
https://example.kintone.com/k/123/?query=text_field%3D%22kintone%22%20and%20choice_field%20in%20(%22A%22)

This will be doing the same filter as the following filter on Kintone:

Filtering Screenshot

Limitations

This query can only be used on the desktop.