Inovice的对象过滤器创建日期
问题描述:
我正在使用rest API来获取其创建日期大于某个日期的发票(例如:2015年9月1日之后).
I am using rest API to get invoices whose create date is greater than some date (eg: After 1st September 2015).
GET
https://{{sluser}}:{{slkey}}@api.softlayer.com/rest/v3.1/SoftLayer_Account/getInvoices?objectFilter={"createDate":{"operation":"greaterThanDate","options":[{"name":"date", "value":"10/01/2015"}]}}&resultLimit=1,5
但是,这似乎是前5张发票.我现在可以在objectFilter中出什么问题吗?另外如何指定日期格式dd-MM-YYYY
或mm-dd-yyyy
或yyyy-mm-dd
?
but this seems to be giving first 5 invoices. May I now what is wrong in the objectFilter? Also how can I specify the date format dd-MM-YYYY
or mm-dd-yyyy
or yyyy-mm-dd
?
答
尝试以下REST请求:
Try the following REST request:
https://[username]:[apikey] @api.softlayer.com/rest/v3/SoftLayer_Account/getInvoices?objectFilter={ "invoices": { "createDate": { "operation": "greaterThanDate", "options": [ { "name": "date", "value": [ "01/22/2016" ] } ] } } }&objectMask=mask[createDate]
Method: GET
位置: date format
是mm-dd-yyyy
.
这是另一个使用"betweenDate"的示例:
This is other example using "betweenDate":
https://[username]:[apikey]@api.softlayer.com/rest/v3/SoftLayer_Account/getInvoices?objectFilter={ "invoices": { "createDate": { "operation": "betweenDate", "options": [ { "name": "startDate", "value": ["02/01/2014"] }, { "name": "endDate", "value": ["02/13/2014"] } ] } } }&objectMask=mask[createDate]
Method: GET
参考文献: