quickbooks: appmixer.quickbooks.accounting.FindCustomer

Basic Information

Name

appmixer.quickbooks.accounting.FindCustomer

Version

1.0.2

Visibility

Public

Description

Find a customer in your QuickBooks.

Input Ports

in

Field	Type	Description
Filter	expression	Filter by customer property.

Output Ports

out

Field	Type	Description
Customer Primary Email Addr Address		-
Customer Sync Token		-
Customer Domain		-
Customer Given Name		-
Customer Display Name		-
Customer Bill With Parent		-
Customer Fully Qualified Name		-
Customer Company Name		-
Customer Family Name		-
Customer Sparse		-
Customer Primary Phone Free Form Number		-
Customer Active		-
Customer Job		-
Customer Balance With Jobs		-
Customer Bill Addr City		-
Customer Bill Addr Line 1		-
Customer Bill Addr Line 2		-
Customer Bill Addr Line 3		-
Customer Bill Addr Line 4		-
Customer Bill Addr Line 5		-
Customer Bill Addr Postal Code		-
Customer Bill Addr Lat		-
Customer Bill Addr Long		-
Customer Bill Addr Country Sub Division Code		-
Bill Addr Country		-
Customer Bill Addr Id		-
Customer Ship Addr City		-
Customer Ship Addr Line 5		-
Customer Ship Addr Line 4		-
Customer Ship Addr Line 3		-
Customer Ship Addr Line 2		-
Customer Ship Addr Line 1		-
Customer Ship Addr Postal Code		-
Customer Ship Addr Lat		-
Customer Ship Addr Long		-
Customer Ship Addr Country Sub Division Code		-
Customer Ship Addr Country		-
Customer Ship Addr Id		-
Customer Preferred Delivery Method		-
Customer Taxable		-
Customer Print On Check Name		-
Customer Balance		-
Customer Id		-
Customer Meta Data Create Time		-
Customer Meta Data Last Updated Time		-
Time		-

notFound

Field	Type	Description
Search Query		-

Full Metadata

#metadata-viewer { display: none; }{ "name": "appmixer.quickbooks.accounting.FindCustomer", "author": "Harsha Surisetty <harsha@client.io>", "description": "Find a customer in your QuickBooks.", "version": "1.0.2", "auth": { "service": "appmixer:quickbooks", "scope": [ "com.intuit.quickbooks.accounting", "openid", "profile", "email", "phone", "address" ] }, "inPorts": [ { "name": "in", "inspector": { "inputs": { "filter": { "type": "expression", "label": "Filter", "levels": [ "AND" ], "index": 1, "tooltip": "Filter by customer property.", "fields": { "property": { "type": "select", "label": "Property", "index": 1, "tooltip": "Select a property/attribute name to filter.", "options": [ { "label": "Display Name", "value": "DisplayName" }, { "label": "Given Name", "value": "GivenName" }, { "label": "Middle Name", "value": "MiddleName" }, { "label": "Family Name", "value": "FamilyName" }, { "label": "Primary Email Address", "value": "PrimaryEmailAddr" }, { "label": "Fully Qualified Name", "value": "FullyQualifiedName" }, { "label": "Company Name", "value": "CompanyName" }, { "label": "Primary Phone Number", "value": "PrimaryPhoneNumber" }, { "label": "Mobile Phone Number", "value": "MobilePhoneNumber" }, { "label": "Alternate Phone Number", "value": "AlternatePhoneNumber" }, { "label": "Fax Number", "value": "FaxNumber" }, { "label": "Address", "value": "Address" }, { "label": "Resale Number", "value": "ResaleNumber" }, { "label": "Primary Tax Identifier", "value": "PrimaryTaxIdentifier" }, { "label": "Secondary Tax Identifier", "value": "SecondaryTaxIdentifier" }, { "label": "AR Account Value", "value": "ArAccountValue" }, { "label": "AR Account Name", "value": "ArAccountName" }, { "label": "GSTIN", "value": "Gstin" }, { "label": "GST Registration Type", "value": "GstRegistrationType" }, { "label": "Customer Type", "value": "CustomerType" }, { "label": "Business Number", "value": "BusinessNumber" }, { "label": "Open Balance Date", "value": "OpenBalanceDate" }, { "label": "Create Time", "value": "CreateTime" }, { "label": "Last Updated Time", "value": "LastUpdatedTime" }, { "label": "Notes", "value": "Notes" }, { "label": "Website Address", "value": "WebsiteAddress" }, { "label": "Balance", "value": "Balance" }, { "label": "Ship Address Line 1", "value": "ShipAddressLine1" }, { "label": "Ship Address Line 2", "value": "ShipAddressLine2" }, { "label": "Ship Address City", "value": "ShipAddressCity" }, { "label": "Ship Address Postal Code", "value": "ShipAddressPostalCode" }, { "label": "Bill Address Line 1", "value": "BillAddressLine1" }, { "label": "Bill Address Line 2", "value": "BillAddressLine2" }, { "label": "Bill Address City", "value": "BillAddressCity" }, { "label": "Bill Address Postal Code", "value": "BillAddressPostalCode" } ] }, "operator": { "type": "select", "label": "Operator", "index": 2, "tooltip": "Provide a name of the signer.", "options": [ { "label": "=", "value": "=" }, { "label": "<", "value": "<" }, { "label": ">", "value": ">" }, { "label": "<=", "value": "<=" }, { "label": ">=", "value": ">=" }, { "label": "IN", "value": "IN" }, { "label": "LIKE", "value": "LIKE" } ] }, "value": { "type": "text", "label": "Value", "index": 3, "tooltip": "Provide an attribute value." } } } } }, "schema": { "type": "object", "properties": { "filter": { "type": "object" } }, "required": [ "filter" ] } } ], "outPorts": [ { "name": "out", "options": [ { "label": "Customer Primary Email Addr Address", "value": "Customer.PrimaryEmailAddr.Address" }, { "label": "Customer Sync Token", "value": "Customer.SyncToken" }, { "label": "Customer Domain", "value": "Customer.domain" }, { "label": "Customer Given Name", "value": "Customer.GivenName" }, { "label": "Customer Display Name", "value": "Customer.DisplayName" }, { "label": "Customer Bill With Parent", "value": "Customer.BillWithParent" }, { "label": "Customer Fully Qualified Name", "value": "Customer.FullyQualifiedName" }, { "label": "Customer Company Name", "value": "Customer.CompanyName" }, { "label": "Customer Family Name", "value": "Customer.FamilyName" }, { "label": "Customer Sparse", "value": "Customer.sparse" }, { "label": "Customer Primary Phone Free Form Number", "value": "Customer.PrimaryPhone.FreeFormNumber" }, { "label": "Customer Active", "value": "Customer.Active" }, { "label": "Customer Job", "value": "Customer.Job" }, { "label": "Customer Balance With Jobs", "value": "Customer.BalanceWithJobs" }, { "label": "Customer Bill Addr City", "value": "Customer.BillAddr.City" }, { "label": "Customer Bill Addr Line 1", "value": "Customer.BillAddr.Line1" }, { "label": "Customer Bill Addr Line 2", "value": "Customer.BillAddr.Line2" }, { "label": "Customer Bill Addr Line 3", "value": "Customer.BillAddr.Line3" }, { "label": "Customer Bill Addr Line 4", "value": "Customer.BillAddr.Line4" }, { "label": "Customer Bill Addr Line 5", "value": "Customer.BillAddr.Line5" }, { "label": "Customer Bill Addr Postal Code", "value": "Customer.BillAddr.PostalCode" }, { "label": "Customer Bill Addr Lat", "value": "Customer.BillAddr.Lat" }, { "label": "Customer Bill Addr Long", "value": "Customer.BillAddr.Long" }, { "label": "Customer Bill Addr Country Sub Division Code", "value": "Customer.BillAddr.CountrySubDivisionCode" }, { "label": "Bill Addr Country", "value": "BillAddr.Country" }, { "label": "Customer Bill Addr Id", "value": "Customer.BillAddr.Id" }, { "label": "Customer Ship Addr City", "value": "Customer.ShipAddr.City" }, { "label": "Customer Ship Addr Line 5", "value": "Customer.ShipAddr.Line5" }, { "label": "Customer Ship Addr Line 4", "value": "Customer.ShipAddr.Line4" }, { "label": "Customer Ship Addr Line 3", "value": "Customer.ShipAddr.Line3" }, { "label": "Customer Ship Addr Line 2", "value": "Customer.ShipAddr.Line2" }, { "label": "Customer Ship Addr Line 1", "value": "Customer.ShipAddr.Line1" }, { "label": "Customer Ship Addr Postal Code", "value": "Customer.ShipAddr.PostalCode" }, { "label": "Customer Ship Addr Lat", "value": "Customer.ShipAddr.Lat" }, { "label": "Customer Ship Addr Long", "value": "Customer.ShipAddr.Long" }, { "label": "Customer Ship Addr Country Sub Division Code", "value": "Customer.ShipAddr.CountrySubDivisionCode" }, { "label": "Customer Ship Addr Country", "value": "Customer.ShipAddr.Country" }, { "label": "Customer Ship Addr Id", "value": "Customer.ShipAddr.Id" }, { "label": "Customer Preferred Delivery Method", "value": "Customer.PreferredDeliveryMethod" }, { "label": "Customer Taxable", "value": "Customer.Taxable" }, { "label": "Customer Print On Check Name", "value": "Customer.PrintOnCheckName" }, { "label": "Customer Balance", "value": "Customer.Balance" }, { "label": "Customer Id", "value": "Customer.Id" }, { "label": "Customer Meta Data Create Time", "value": "Customer.MetaData.CreateTime" }, { "label": "Customer Meta Data Last Updated Time", "value": "Customer.MetaData.LastUpdatedTime" }, { "label": "Time", "value": "time" } ] }, { "name": "notFound", "options": [ { "label": "Search Query", "value": "query" } ] } ], "icon": "data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHZpZXdCb3g9IjAgMCAyNTAwIDI1MDAiPjxjaXJjbGUgY3g9IjEyNTAiIGN5PSIxMjUwIiByPSIxMjUwIiBmaWxsPSIjMmNhMDFjIi8+PHBhdGggZmlsbD0iI2ZmZiIgZD0iTTMwMS4zIDEyNDkuNmMuMSAyODIuNiAyMjggNTEyLjQgNTEwLjYgNTE0LjloNzIuM3YtMTg4LjloLTcyLjNjLTE3NS4yIDQ3LjgtMzU1LjktNTUuNS00MDMuNi0yMzAuNy0uNC0xLjQtLjctMi44LTEuMS00LjItNDkuMS0xNzcuNSA1My43LTM2MS40IDIzMC42LTQxMi41aDM2LjFhMzIyIDMyMiAwIDAgMSAxMzcuNSAwSDk4N3YxMDAyLjljLS45IDEwNi4xIDg0LjQgMTkyLjkgMTkwLjUgMTkzLjlWNzI5LjZIODEzYy0yODQuNiAxLjUtNTE0IDIzMy40LTUxMi41IDUxOHYuMXptMTM4Ny41LTUxOS44aC03Mi4zdjE5OC45aDcyLjNjMTc0LjgtNDcuNyAzNTUuMSA1NS4zIDQwMi44IDIzMCAuNCAxLjMuNyAyLjcgMS4xIDQgNDguOCAxNzYuOS01My43IDM2MC4xLTIyOS45IDQxMS4xaC0zNi4xYTMyMiAzMjIgMCAwIDEtMTM3LjUgMGgtMTc1LjZWNTcxYy45LTEwNi4xLTg0LjQtMTkyLjktMTkwLjUtMTkzLjl2MTM5Ny40aDM2NC41YzI4Ny4xLTQuNSA1MTYuMi0yNDAuOCA1MTEuOC01MjcuOS00LjQtMjgwLjgtMjMwLjktNTA3LjQtNTExLjgtNTExLjh6Ii8+PC9zdmc+" }