Hello Linner,
In conclusion, we are still unsure of the cause of the problem.
However, we think the settings may be incorrect after checking each request.
I also wanted to apologize, but in the case of support in Japan, we cannot check the operation by directly logging into the customer’s environment.
Therefore, we have tried to verify the operation based on your provided information, but the cause is still unknown.
However, we noticed that in the second row of the table, the status code for status is changed to “Status.”
> ‘query’: ‘Status in (“未开始”)’,
Please check and see if changing “Status” to " ステータス" will solve the issue.
> ‘query’: ‘ステータス in (“未开始”)’,
It is also possible that the error is caused by referencing a different field, such as a “drop-down” field.
If changing the status field code to Japanese does not resolve the problem, kindly check the following.
-
Add a record with the status “未开始.”
-
Set the language to 中文（简体）, and then execute the following code at the time mentioned in your original post.
var body = {
‘app’: 3
};
kintone.api(kintone.api.url(’/k/v1/records’, true), ‘GET’, body, function(resp) {
// success
console.log(resp);
}, function(error) {
// error
console.log(error);
});
-
Check the following from within the response obtained in 2.
- Check if the field code of ステータス (type: “STATUS”) is “Status.”
- Check that the status value (value) of the record added in 1. is “未开始.”
- Obtain a screenshot to show the status of 3.
(Please send us a screenshot like last time.)
There was no status of “Now open” in the first question, which seems to be the reason for the error.
To add, after setting the language to English, we tested it out and then created a new app.
Then, the field code will be in English.
In that state, add a record by doing “Localization Setting” in 中文（簡体）.
If the following process is executed after setting the language to 中文（簡体）, the data can be retrieved without any problem.
var body = {
'app': 5697,
'query': 'Status in ("未开始")',
'fields': ['$id', 'Created_by', 'Created_datetime'],
totalCount: true
};
kintone.api(kintone.api.url('/k/v1/records', true), 'GET', body, function(resp) {
// success
console.log(resp);
}, function(error) {
// error
console.log(error);
