When using JSON format for the Body, can the following object array specification be registered to a single resource with a single resource registration API use?
E.g.）
[
{Key1:a,Key2:b,Key3:2015-07-21 10:00},
{Key1:d,Key2:e,Key3:2015-07-21 11:00},
{Key1:g,Key2:h,Key3:2015-07-21 12:00}
]
When creating arrays you need to close off associated keys and values with {}.
In addition, values need to be enclosed with double quotation marks when treating them as character strings other than numerical values.
{
"KeyArray": [
{"Key1":"a","Key2":"b","Key3":"2015-07-21 10:00"},
{"Key1":"d","Key2":"e","Key3":"2015-07-21 11:00"},
{"Key1":"g","Key2":"h","Key3":"2015-07-21 12:00"}
]
}
I would like to acquire records with no values stored to a key in JSON data.
Would setting filter=<key> eq null as the filter condition result in all records without a value stored to the <key> being acquired? Or would this result in all records not being acquired (search results: 0 records)?
All records without the <key> would be acquired. The following call would be made from the resource path.
<Resource path>/_past?$filter=<key> eq null
I would like to acquire records with a key stored in JSON data. Would setting filter=<key> ne null as the filter condition result in all records with a value stored to the <key> being acquired?
All records with the <key> would be acquired.
What filter conditions should I write to acquire all data for a certain key?
You can use skip and top to acquire all data items in lots of 1,000 items at a time.
When dealing with large data sizes for each data item, we recommend reducing the number of data items acquired at a time to 10, or whatever amount is appropriate.
Acquire first 10 data items: ?$top=10
Acquire next 10 data items: ?$top=10&skip=10
Acquire the next 10 data items again: ?$top=10&skip=20