If I have billing item and order item details is there any attribute which tells if the resource actually exists in SL? for eg: virtual guest whether is available or de-provisioned? there might be other resources as well eg: network_vlan etc.
This REST example may help you:
https://[username]:[apikey]@api.softlayer.com/rest/v3/SoftLayer_Billing_Item/[billing_item_id]/getObject?objectMask=mask[id,cancellationDate,activeFlag]
Method: GET
Where:
cancellationDate:
A billing item's cancellation date. A billing item with a cancellation date in the past is not charged on your SoftLayer invoice. Cancellation dates in the future indicate the current billing item is active, but will be cancelled and not charged for in the future. A billing item with a null cancellation date is also considered an active billing item and is charged once every billing cycle.
The response of a canceled billing item would be:
{
"cancellationDate": "2014-05-16T13:53:55-05:00",
"id": 18450000,
"activeFlag": false
}
Reference: SoftLayer_Billing_Item