softlayer billing api to get a past invoice

Question

wondering is there a softlayer rest api that i can use to get an invoice for a particular month from the past.

For instance, i want to pull the invoice for the month of April 2016. i looked at Softlayer Billing Invoice service but in vain.

Also i do see a property called createDate on an invoice object but not sure if it can be of any help for the given scenario.

Answer 1

It would be possible using Object Filters, in this case it's necessary to use a filter between dates, try the below example for it:

https://$username:[email protected]/rest/v3.1/SoftLayer_Account/getInvoices?objectFilter={"invoices":{"createDate":{"operation":"betweenDate","options":[{"name":"startDate","value":["04/01/2016 00:00:00"]},{"name":"endDate","value":["04/30/2016 23:59:59"]}]}}}
    
Method: Get

It will display invoices between 04/01/2016 00:00:00 and 04/30/2016 23:59:59

References:

• SoftLayer_Account::getInvoices

---

Updated

How to get a single invoice for a specific month?

You need to get the information from invoice with "typeCode": "RECURRING", in this case, you can use the following request:

https://$username:[email protected]/rest/v3.1/SoftLayer_Account/getInvoices?objectFilter={"invoices":{"createDate":{"operation":"betweenDate","options":[{"name":"startDate","value":["06/01/2016 00:00:00"]},{"name":"endDate","value":["06/30/2016 23:59:59"]}]}, "typeCode":{"operation":"RECURRING"}}}

Method: Get