CommercientCPQ (Preview)

Commercient CPQ is a cloud sales engine for creating Quotes and processing Sales Orders online. Commercient CPQ is used to process both B2B and B2C orders. CPQ allows for complex pricing and configuration options. Commercient CPQ enables you to begin an Order or Quote directly in the CPQ or from any system such as CRM (Microsoft, Salesforce, Zoho, Sugar) or eCommerce (Magento, WooCommerce, BigCommerce, Shopify) and sync the new customer and order details to Commercient CPQ for finalization and optional credit card processing. Commercient CPQ can help you build a quote with optional components, BOM, and Kit items all while managing your pricing requirements. Commercient CPQ can also provides Inventory Availability queries from your ERP system so that you always know what you can promise your customers. The final CPQ orders or invoices can be processed by your ERP (e.g. Dynamics 365, Dynamics NAV, Freshbooks, QuickBooks, Sage) or transacted to any other connected system. With the Flow connector Commercient CPQ allows for thousands of possibilities for managing your Commercient CPQ order cycle whether you are looking to integrate a Field Service solution that dovetails into the CPQ process, or Project Management tools to manage a new sale you have made via CPQ. Integrate the solution you need using Microsoft Flow and Commercient CPQ.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
Flow Premium All Flow regions except the following:
     -   US Government (GCC)
PowerApps Premium All PowerApps regions except the following:
     -   US Government (GCC)

Creating a connection

To connect your account, you will need the following information:

Name Type Description
username securestring

The username for this api

password securestring

The password for this api

Throttling Limits

Name Calls Renewal Period
API calls per connection10060 seconds

Actions

Create new Customer in CPQ

Create new Customer in CPQ

Create new customer in SAGE100

Create new customer in SAGE100

Create new Product in CPQ

Create new Product in CPQ

Create new Salesorder in CPQ

Create new Salesorder in CPQ

Create new Salesorder in SAGE100

Create new Salesorder in SAGE100

Create new Customer in CPQ

Create new Customer in CPQ

Parameters

Name Key Required Type Description
BillingCity
BillingCity string

BillingCity

BillingCounty
BillingCounty string

BillingCounty

BillingPostalCode
BillingPostalCode string

BillingPostalCode

BillingState
BillingState string

BillingState

BillingStreet
BillingStreet string

BillingStreet

GUID
GUID string

GUID

Name
Name string

Name

ShippingCity
ShippingCity string

ShippingCity

ShippingCountry
ShippingCountry string

ShippingCountry

ShippingPostalCode
ShippingPostalCode string

ShippingPostalCode

ShippingState
ShippingState string

ShippingState

ShippingStreet
ShippingStreet string

ShippingStreet

acnm
acnm string

acnm

Returns

Name Path Type Description
code
code integer

code

BillingCity
data.BillingCity string

BillingCity

BillingCounty
data.BillingCounty string

BillingCounty

BillingPostalCode
data.BillingPostalCode string

BillingPostalCode

BillingState
data.BillingState string

BillingState

BillingStreet
data.BillingStreet string

BillingStreet

GUID
data.GUID string

GUID

Name
data.Name string

Name

ShippingCity
data.ShippingCity string

ShippingCity

ShippingCountry
data.ShippingCountry string

ShippingCountry

ShippingPostalCode
data.ShippingPostalCode string

ShippingPostalCode

ShippingState
data.ShippingState string

ShippingState

ShippingStreet
data.ShippingStreet string

ShippingStreet

acnm
data.acnm string

acnm

message
message string

message

Create new customer in SAGE100

Create new customer in SAGE100

Parameters

Name Key Required Type Description
ARDivisionNo
ARDivisionNo string

ARDivisionNo

AddressLine1
AddressLine1 string

AddressLine1

AddressLine2
AddressLine2 string

AddressLine2

AddressLine3
AddressLine3 string

AddressLine3

BatchFax
BatchFax boolean

BatchFax

City
City string

City

Comment
Comment string

Comment

ContactCode
ContactCode string

ContactCode

CountryCode
CountryCode string

CountryCode

CreditHold
CreditHold boolean

CreditHold

CreditLimit
CreditLimit integer

CreditLimit

CustomerDiscountRate
CustomerDiscountRate integer

CustomerDiscountRate

CustomerName
CustomerName string

CustomerName

CustomerNo
CustomerNo string

CustomerNo

CustomerType
CustomerType string

CustomerType

DefaultCreditCardPmtType
DefaultCreditCardPmtType string

DefaultCreditCardPmtType

DefaultItemCode
DefaultItemCode string

DefaultItemCode

DefaultPaymentType
DefaultPaymentType string

DefaultPaymentType

EmailAddress
EmailAddress string

EmailAddress

FaxNo
FaxNo string

FaxNo

OpenItemCustomer
OpenItemCustomer boolean

OpenItemCustomer

PriceLevel
PriceLevel string

PriceLevel

PrimaryShipToCode
PrimaryShipToCode string

PrimaryShipToCode

PrintDunningMessage
PrintDunningMessage boolean

PrintDunningMessage

ResidentialAddress
ResidentialAddress boolean

ResidentialAddress

SalespersonNo
SalespersonNo string

SalespersonNo

ShipMethod
ShipMethod string

ShipMethod

State
State string

State

StatementCycle
StatementCycle string

StatementCycle

TaxExemptNo
TaxExemptNo string

TaxExemptNo

TaxSchedule
TaxSchedule string

TaxSchedule

TelephoneExt
TelephoneExt string

TelephoneExt

TelephoneNo
TelephoneNo string

TelephoneNo

TermsCode
TermsCode string

TermsCode

URLAddress
URLAddress string

URLAddress

ZipCode
ZipCode string

ZipCode

Returns

Name Path Type Description
code
code integer

code

ARDivisionNo
data.ARDivisionNo string

ARDivisionNo

AddressLine1
data.AddressLine1 string

AddressLine1

AddressLine2
data.AddressLine2 string

AddressLine2

AddressLine3
data.AddressLine3 string

AddressLine3

BatchFax
data.BatchFax boolean

BatchFax

City
data.City string

City

Comment
data.Comment string

Comment

ContactCode
data.ContactCode string

ContactCode

CountryCode
data.CountryCode string

CountryCode

CreditHold
data.CreditHold boolean

CreditHold

CreditLimit
data.CreditLimit integer

CreditLimit

CustomerDiscountRate
data.CustomerDiscountRate integer

CustomerDiscountRate

CustomerName
data.CustomerName string

CustomerName

CustomerNo
data.CustomerNo string

CustomerNo

CustomerType
data.CustomerType string

CustomerType

DefaultCreditCardPmtType
data.DefaultCreditCardPmtType string

DefaultCreditCardPmtType

DefaultItemCode
data.DefaultItemCode string

DefaultItemCode

DefaultPaymentType
data.DefaultPaymentType string

DefaultPaymentType

EmailAddress
data.EmailAddress string

EmailAddress

FaxNo
data.FaxNo string

FaxNo

OpenItemCustomer
data.OpenItemCustomer boolean

OpenItemCustomer

PriceLevel
data.PriceLevel string

PriceLevel

PrimaryShipToCode
data.PrimaryShipToCode string

PrimaryShipToCode

PrintDunningMessage
data.PrintDunningMessage boolean

PrintDunningMessage

ResidentialAddress
data.ResidentialAddress boolean

ResidentialAddress

SalespersonNo
data.SalespersonNo string

SalespersonNo

ShipMethod
data.ShipMethod string

ShipMethod

State
data.State string

State

StatementCycle
data.StatementCycle string

StatementCycle

TaxExemptNo
data.TaxExemptNo string

TaxExemptNo

TaxSchedule
data.TaxSchedule string

TaxSchedule

TelephoneExt
data.TelephoneExt string

TelephoneExt

TelephoneNo
data.TelephoneNo string

TelephoneNo

TermsCode
data.TermsCode string

TermsCode

URLAddress
data.URLAddress string

URLAddress

ZipCode
data.ZipCode string

ZipCode

message
message string

message

Create new Product in CPQ

Create new Product in CPQ

Parameters

Name Key Required Type Description
StockCode
StockCode string

StockCode

Returns

Name Path Type Description
code
code integer

code

StockCode
data.StockCode string

StockCode

message
message string

message

Create new Salesorder in CPQ

Create new Salesorder in CPQ

Parameters

Name Key Required Type Description
OrderHeaderGUID
OrderHeaderGUID string

OrderHeaderGUID

Price
Price string

Price

Qty
Qty string

Qty

StockCode
StockCode string

StockCode

Returns

Name Path Type Description
code
code integer

code

OrderHeaderGUID
data.OrderHeaderGUID string

OrderHeaderGUID

SalesOrderLineItem
data.SalesOrderLineItem array of object

SalesOrderLineItem

Price
data.SalesOrderLineItem.Price string

Price

Qty
data.SalesOrderLineItem.Qty string

Qty

StockCode
data.SalesOrderLineItem.StockCode string

StockCode

message
message string

message

Create new Salesorder in SAGE100

Create new Salesorder in SAGE100

Parameters

Name Key Required Type Description
ARDivisionNo
ARDivisionNo string

ARDivisionNo

BatchFax
BatchFax boolean

BatchFax

BillToAddress1
BillToAddress1 string

BillToAddress1

BillToAddress2
BillToAddress2 string

BillToAddress2

BillToAddress3
BillToAddress3 string

BillToAddress3

BillToCity
BillToCity string

BillToCity

BillToCountryCode
BillToCountryCode string

BillToCountryCode

BillToName
BillToName string

BillToName

BillToState
BillToState string

BillToState

BillToZipCode
BillToZipCode string

BillToZipCode

Comment
Comment string

Comment

ConfirmTo
ConfirmTo string

ConfirmTo

CustomerNo
CustomerNo string

CustomerNo

CustomerPONo
CustomerPONo string

CustomerPONo

CycleCode
CycleCode string

CycleCode

EmailAddress
EmailAddress string

EmailAddress

FOB
FOB string

FOB

FaxNo
FaxNo string

FaxNo

MasterRepeatingOrderNo
MasterRepeatingOrderNo string

MasterRepeatingOrderNo

NumberOfShippingLabels
NumberOfShippingLabels integer

NumberOfShippingLabels

OrderDate
OrderDate string

OrderDate

OrderStatus
OrderStatus string

OrderStatus

OrderType
OrderType string

OrderType

PrintPickingSheets
PrintPickingSheets boolean

PrintPickingSheets

PrintSalesOrders
PrintSalesOrders boolean

PrintSalesOrders

CommentText
CommentText string

CommentText

Discount
Discount integer

Discount

ExtensionAmt
ExtensionAmt integer

ExtensionAmt

ItemCode
ItemCode string

ItemCode

ItemCodeDesc
ItemCodeDesc string

ItemCodeDesc

ItemType
ItemType string

ItemType

ItemWarehouseCode
ItemWarehouseCode string

ItemWarehouseCode

QuantityOrdered
QuantityOrdered integer

QuantityOrdered

UnitOfMeasure
UnitOfMeasure string

UnitOfMeasure

UnitPrice
UnitPrice integer

UnitPrice

SalesOrderNo
SalesOrderNo string

SalesOrderNo

SalespersonNo
SalespersonNo string

SalespersonNo

ShipExpireDate
ShipExpireDate string

ShipExpireDate

ShipToAddress1
ShipToAddress1 string

ShipToAddress1

ShipToAddress2
ShipToAddress2 string

ShipToAddress2

ShipToAddress3
ShipToAddress3 string

ShipToAddress3

ShipToCity
ShipToCity string

ShipToCity

ShipToCode
ShipToCode string

ShipToCode

ShipToCountryCode
ShipToCountryCode string

ShipToCountryCode

ShipToName
ShipToName string

ShipToName

ShipToState
ShipToState string

ShipToState

ShipToZipCode
ShipToZipCode string

ShipToZipCode

ShipVia
ShipVia string

ShipVia

ShipWeight
ShipWeight integer

ShipWeight

ShipZoneActual
ShipZoneActual string

ShipZoneActual

SplitCommissions
SplitCommissions string

SplitCommissions

TaxExemptNo
TaxExemptNo string

TaxExemptNo

TaxSchedule
TaxSchedule string

TaxSchedule

TermsCode
TermsCode string

TermsCode

WarehouseCode
WarehouseCode string

WarehouseCode

Returns

Name Path Type Description
code
code integer

code

ARDivisionNo
data.ARDivisionNo string

ARDivisionNo

BatchFax
data.BatchFax boolean

BatchFax

BillToAddress1
data.BillToAddress1 string

BillToAddress1

BillToAddress2
data.BillToAddress2 string

BillToAddress2

BillToAddress3
data.BillToAddress3 string

BillToAddress3

BillToCity
data.BillToCity string

BillToCity

BillToCountryCode
data.BillToCountryCode string

BillToCountryCode

BillToName
data.BillToName string

BillToName

BillToState
data.BillToState string

BillToState

BillToZipCode
data.BillToZipCode string

BillToZipCode

Comment
data.Comment string

Comment

ConfirmTo
data.ConfirmTo string

ConfirmTo

CustomerNo
data.CustomerNo string

CustomerNo

CustomerPONo
data.CustomerPONo string

CustomerPONo

CycleCode
data.CycleCode string

CycleCode

EmailAddress
data.EmailAddress string

EmailAddress

FOB
data.FOB string

FOB

FaxNo
data.FaxNo string

FaxNo

MasterRepeatingOrderNo
data.MasterRepeatingOrderNo string

MasterRepeatingOrderNo

NumberOfShippingLabels
data.NumberOfShippingLabels integer

NumberOfShippingLabels

OrderDate
data.OrderDate string

OrderDate

OrderStatus
data.OrderStatus string

OrderStatus

OrderType
data.OrderType string

OrderType

PrintPickingSheets
data.PrintPickingSheets boolean

PrintPickingSheets

PrintSalesOrders
data.PrintSalesOrders boolean

PrintSalesOrders

SalesOrderLineItem
data.SalesOrderLineItem array of object

SalesOrderLineItem

CommentText
data.SalesOrderLineItem.CommentText string

CommentText

Discount
data.SalesOrderLineItem.Discount integer

Discount

ExtensionAmt
data.SalesOrderLineItem.ExtensionAmt integer

ExtensionAmt

ItemCode
data.SalesOrderLineItem.ItemCode string

ItemCode

ItemCodeDesc
data.SalesOrderLineItem.ItemCodeDesc string

ItemCodeDesc

ItemType
data.SalesOrderLineItem.ItemType string

ItemType

ItemWarehouseCode
data.SalesOrderLineItem.ItemWarehouseCode string

ItemWarehouseCode

QuantityOrdered
data.SalesOrderLineItem.QuantityOrdered integer

QuantityOrdered

UnitOfMeasure
data.SalesOrderLineItem.UnitOfMeasure string

UnitOfMeasure

UnitPrice
data.SalesOrderLineItem.UnitPrice integer

UnitPrice

SalesOrderNo
data.SalesOrderNo string

SalesOrderNo

SalespersonNo
data.SalespersonNo string

SalespersonNo

ShipExpireDate
data.ShipExpireDate string

ShipExpireDate

ShipToAddress1
data.ShipToAddress1 string

ShipToAddress1

ShipToAddress2
data.ShipToAddress2 string

ShipToAddress2

ShipToAddress3
data.ShipToAddress3 string

ShipToAddress3

ShipToCity
data.ShipToCity string

ShipToCity

ShipToCode
data.ShipToCode string

ShipToCode

ShipToCountryCode
data.ShipToCountryCode string

ShipToCountryCode

ShipToName
data.ShipToName string

ShipToName

ShipToState
data.ShipToState string

ShipToState

ShipToZipCode
data.ShipToZipCode string

ShipToZipCode

ShipVia
data.ShipVia string

ShipVia

ShipWeight
data.ShipWeight integer

ShipWeight

ShipZoneActual
data.ShipZoneActual string

ShipZoneActual

SplitCommissions
data.SplitCommissions string

SplitCommissions

TaxExemptNo
data.TaxExemptNo string

TaxExemptNo

TaxSchedule
data.TaxSchedule string

TaxSchedule

TermsCode
data.TermsCode string

TermsCode

WarehouseCode
data.WarehouseCode string

WarehouseCode

message
message string

message