Choose where you’d like to start

Fetch record from Quickbooks using the record ID

Overview

Fetch a record from Quickbooks using the record ID.

Note: This task is applicable only to Zoho Creator.

Syntax

<variable> = intuit.quickbooks.getRecordById(<quickbooks_connection>, <quickbooks_module>, <company_ID><record_ID>);

where,

ParameterDescriptionData 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.

Customer

Vendor

Item

Invoice
AccountEmployee Department
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. 

response = intuit.quickbooks.getRecordById("Quickbooks", "Customer", "1241802285", "12");

where,

ParameterDescription
"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
responseis 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"
}
]"
}

Related Links

Get Started Now

Execute