Description Usage Arguments Details See Also Examples
kntn_record()
gets a single record from the specified kintone application.
kntn_records()
retrieves multiple records at once. If the number of records is more than
records_per_request
(the default is 100), kntn_records()
automatically splits the
request into smaller subrequests.
1 2 3 4 5 6 7 8 9 10 11 12 | kntn_record(app, id, as = c("data.frame", "list", "text"), verbose = FALSE)
kntn_records(
app,
fields = NULL,
query = "",
max_records = 1000L,
offset = 0L,
records_per_request = 100L,
as = c("data.frame", "list", "text"),
verbose = FALSE
)
|
app |
App ID. |
id |
Record ID. |
as |
Desired type of output: |
verbose |
If |
fields |
Names of fields. |
query |
Query (e.g. |
max_records |
Max number of records to get. |
offset |
Offset of records. |
records_per_request |
Number of records per request (max: 100). |
A field will be converted to the correspondent object by the type:
RECORD_NUMBER: character
__ID__: integer
__REVISION__: integer
CREATOR: character
(code)
CREATED_TIME: POSIXct
MODIFIER: character
(code)
UPDATED_TIME: POSIXct
SINGLE_LINE_TEXT: character
NUMBER: numeric
CALC: character
MULTI_LINE_TEXT: character
RICH_TEXT: character
CHECK_BOX: nested character
RADIO_BUTTON: character
DROP_DOWN: character
MULTI_SELECT: nested character
FILE: nested tbl_df
LINK: character
DATE: Date
TIME: character
(R has no correspondent class for this)
DATETIME: POSIXct
USER_SELECT: nested character
(code)
ORGANIZATION_SELECT: nested character
(code)
GROUP_SELECT: nested character
(code)
CATEGORY: nested character
STATUS: character
STATUS_ASSIGNEE: character
SUBTABLE: nested tbl
Some types will be converted to nested objects. You can unnest these fields by kntn_unnest.
https://developer.kintone.io/hc/en-us/articles/213149287/
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | ## Not run:
kntn_set_auth()
app <- 10
# get a single record
d <- kntn_record(app, id = 1)
# get records up to 1000 (default)
d <- kntn_records(app)
# get records up to 5000 records at the latency of 500 records/request.
d <- kntn_records(app, max_records = 5000, records_per_request = 500L)
# get records as list
d <- kntn_records(app, as = "list")
# get records matched with the specified query and fields.
# See https://developer.kintone.io/hc/en-us/articles/213149287/ for the query syntax
d <- kntn_records(app, fields = c("timestamp", "value"),
query = "updated_time > \"2016-10-03T09:00:00+0900\"")
# Some types like SUBTABLE are converted as nested data.frame.
# You can unnest them by using kntn_unnest.
kntn_unnest(d)
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.