Fetch record from Quickbooks using the record ID
Table of ContentsUp
Overview
Fetch a record from Quickbooks using the record ID.
Note: This task is applicable only to Zoho Creator.
Syntax
where,
| Parameter | Description | Data type | ||||||||
<variable> | is the variable which will hold the response returned by Quickbooks. | KEY-VALUE | ||||||||
<quickbooks_connection> | is the name of the Quickbooks connection. | TEXT | ||||||||
<quickbooks_module> | is the name of the module in Quickbooks from where the record will be fetched. Following are the names of applicable modules.
| TEXT | ||||||||
| <company_ID> | refers to the unique ID generated by Quickbooks for each account. You can find this under Your Company -> Account and Settings -> Billing & Subscription -> Company Id in your Quickbooks account. | TEXT | ||||||||
<record_ID> | ID of the record which needs to be fetched. Learn how to fetch the ID of a record after creating it or fetching it. | TEXT | ||||||||
Fetch record by ID from Quickbooks
The following snippet when executed fetches a record based on the specified record ID from the "Customer" module in Quickbooks.
where,
| Parameter | Description |
| "Quickbooks" | is the name of the Quickbooks Connection |
| "Customer" | is the module in Quickbooks, from where the record will be fetched |
| "1241802285" | is the company ID of the account from which the record will be fetched |
| "12" | is the ID of the record which needs to be fetched |
| response | is response returned as map by Quickbooks |
Sample Response
Following is a sample success response returned by Quickbooks:
"UpsellOpportunity__c":null,
"ParentId":null,
"Phone":null,
"TickerSymbol":null,
"SLAExpirationDate__c":null,
"Type":null,
"OwnerId":"00590000002l9KTAAY",
"LastModifiedDate":"2014-08-06T09:58:31.000+0000",
"ShippingState":null,
"AnnualRevenue":1000,
"BillingState":null,
"NumberofLocations__c":null,
"LastActivityDate":null,
"NumberOfEmployees":null,
"BillingPostalCode":null,
"SLASerialNumber__c":null,
"SystemModstamp":"2014-08-06T09:58:31.000+0000",
"ShippingCity":null,
"Description":null,
"BillingCountry":null,
"Site":null,
"ShippingCountry":null,
"LastModifiedById":"00590000002l9KTAAY",
"Website":null,
"ShippingStreet":null,
"AccountNumber":null,
"Fax":null,
"BillingStreet":null,
"SLA__c":null,
"Active__c":null,
"CustomerPriority__c":null,
"MasterRecordId":null,
"Name":"feb",
"BillingCity":null,
"Rating":null,
"CreatedById":"00590000002l9KTAAY",
"CreatedDate":"2014-08-06T09:58:31.000+0000",
"IsDeleted":false,
"Id":"00190000010xPIuAAM",
"Ownership":null,
"attributes":"{" type":"Account",
"url":"/services/data/v20.0/sobjects/Account/00190000010xPIuAAM"
}","ShippingPostalCode":null,
"Sic":null,
"Industry":"Chemicals"
}
The following is a sample failure response, due to incorrect parameter name:
"Error":"[{
" Detail":"Property Name:Can not instanti specified is unsupported or invalid",
"Message":"Request has invalid or unsupported property",
"code":"2010"
}
]"
}