다음을 통해 공유

SOS Inventory (Independent Publisher) (Preview)

  • Reference

Retrieves and updates information in SOS Inventory

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
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name Harold Anderson
URL https://github.com/Harold-Anderson
Email harold@acfo.co
Connector Metadata
Publisher Harold Anderson
Website https://acfo.co
Privacy policy https://acfo.co
Categories Business Management

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Get a Customer

Gets a Customer by ID
Get a Sales Order

Gets a Sales Order by ID
List Items

List Items
List Pick tickets

List Pick Tickets
List Sales Orders

List Sales Orders
Locations

List Locations
Lots

List Lots
Update Pick ticket

Updates a specific pick ticket by setting the values of the parameters passed.

Get a Customer

Operation ID:
GetCustomer

Gets a Customer by ID

Parameters

Name Key Required Type Description
id
 id True number

Customer ID in SOS Inventory.

Returns

Body
customer

Get a Sales Order

Operation ID:
GetSalesOrder

Gets a Sales Order by ID

Parameters

Name Key Required Type Description
id
 id True number

Order ID in SOS Inventory.

Returns

Body
salesorder

List Items

Operation ID:
Item

List Items

Parameters

Name Key Required Type Description
Location
 location string

Inventory at given location
Tags
 tags string

Returns records that match the provided comma separated list of tags.
Type
 type string

Returns records that match the provided item type.
Limit
 limit integer

Limit number of items returned. Default 10

Returns

Name Path Type Description
count
 count integer

The number of results returned in this query.
totalCount
 totalCount integer

Total number of objects
data
 data array of object

Array of items
id
 data.id integer

Item ID
starred
 data.starred integer
syncToken
 data.syncToken integer
name
 data.name string
fullname
 data.fullname string
description
 data.description string
sku
 data.sku string
barcode
 data.barcode string
type
 data.type string
url
 data.url string
tags
 data.tags string
notes
 data.notes string
purchaseDescription
 data.purchaseDescription string
vendorPartNumber
 data.vendorPartNumber string
customerPartNumber
 data.customerPartNumber string
id
 data.vendor.id integer

Vendor ID
name
 data.vendor.name string

Vendor Name
bin
 data.bin string
warranty
 data.warranty string
category
 data.category string
class
 data.class string
id
 data.incomeAccount.id integer
name
 data.incomeAccount.name string
id
 data.cogsAccount.id integer
name
 data.cogsAccount.name string
id
 data.assetAccount.id integer
name
 data.assetAccount.name string
id
 data.expenseAccount.id integer
name
 data.expenseAccount.name string
onhand
 data.onhand number
available
 data.available number
onSO
 data.onSO number
onSR
 data.onSR number
rented
 data.rented number
onWO
 data.onWO number
onPO
 data.onPO number
onRMA
 data.onRMA number
reorderPoint
 data.reorderPoint number
maxStock
 data.maxStock number
leadTime
 data.leadTime number
salesPrice
 data.salesPrice number
baseSalesPrice
 data.baseSalesPrice number
markupPercent
 data.markupPercent number
useMarkup
 data.useMarkup boolean
minimumPrice
 data.minimumPrice number
basePurchaseCost
 data.basePurchaseCost number
purchaseCost
 data.purchaseCost number
costBasis
 data.costBasis number
weight
 data.weight number
volume
 data.volume number
weightUnit
 data.weightUnit string
volumeUnit
 data.volumeUnit string
sublevel
 data.sublevel integer
taxable
 data.taxable boolean
salesTaxCode
 data.salesTaxCode string
purchaseTaxCode
 data.purchaseTaxCode string
willSync
 data.willSync boolean
updateShopify
 data.updateShopify boolean
updateBigCommerce
 data.updateBigCommerce boolean
alwaysShippable
 data.alwaysShippable boolean
hasImage
 data.hasImage boolean
serialTracking
 data.serialTracking boolean
lotTracking
 data.lotTracking boolean
archived
 data.archived boolean
showOnSalesForms
 data.showOnSalesForms boolean
showOnPurchasingForms
 data.showOnPurchasingForms boolean
showOnManufacturingForms
 data.showOnManufacturingForms boolean
customFields
 data.customFields string
uoms
 data.uoms array of
priceTiers
 data.priceTiers array of
summaryOnly
 data.summaryOnly boolean
imageAsBase64String
 data.imageAsBase64String string
imageChanged
 data.imageChanged boolean
commissionRate
 data.commissionRate number
commissionAmount
 data.commissionAmount number
commissionExempt
 data.commissionExempt boolean
syncMessage
 data.syncMessage string
lastSync
 data.lastSync string
keys
 data.keys string
values
 data.values string
__IMTLENGTH__
 data.__IMTLENGTH__ integer
__IMTINDEX__
 data.__IMTINDEX__ integer

List Pick tickets

Operation ID:
PickTicket

List Pick Tickets

Parameters

Name Key Required Type Description
start
 start number

A cursor used in pagination
Limit
 maxresults number

Maximum number of results to return
Summary
 summary string

If present, returns only summary values.
query
 query string

Filter results by matching query.
archived
 archived boolean

Filters by archived or not.
From Date
 from date

Starting transaction date.
To Date
 to date

Ending transaction date.
Location
 location string

Filters according to location.
Location
 status string

Filters according to open/closed.

Returns

Name Path Type Description
count
 count integer

The number of Pick Tickets Returned
totalCount
 totalCount integer

The number of Matching Pick Tickets
data
 data array of pickticket

List Sales Orders

Operation ID:
SalesOrder

List Sales Orders

Parameters

Name Key Required Type Description
start
 start number

A cursor used in pagination
Max Results
 maxresults number

Max Results to return. Default 200.
Type
 status string

Filters by whether transaction is open or closed.
query
 query string

Filter results by matching query.
archived
 archived boolean

Filters by archived or not.
From Date
 from date

Starting transaction date.
To Date
 to date

Ending transaction date.
Location
 location string

Filters according to location.
id
 id number

Returns specific order given id.

Returns

Name Path Type Description
count
 count integer

The number of Sales Orders Returned
totalCount
 totalCount integer

The number of Matching Sales Orders
data
 data array of salesorder

Locations

Operation ID:
Location

List Locations

Parameters

Name Key Required Type Description
Limit
 limit integer

Limit number of locations returned. Default 10

Returns

Name Path Type Description
count
 count integer

The number of Locations Returned
totalCount
 totalCount integer

The number of Matching Locations
data
 data array of object
id
 data.id integer

Location ID
syncToken
 data.syncToken integer

sync token
name
 data.name string

Location Name
binTracking
 data.binTracking boolean

Bin Tracking
bins
 data.bins array of object
id
 data.bins.id integer

ID
syncToken
 data.bins.syncToken integer

sync token
number
 data.bins.number string

Bin Number
location
 data.bins.location string

Location
sortOrder
 data.bins.sortOrder integer

Sort order
line1
 data.address.line1 string

First Line of Address
line2
 data.address.line2 string

Second Line of Address
line3
 data.address.line3 string

Third Line of Address
line4
 data.address.line4 string

Fourth Line of Address
line5
 data.address.line5 string

Fifth Line of Address
city
 data.address.city string

City
stateProvince
 data.address.stateProvince string
postalCode
 data.address.postalCode string

Postal Code
country
 data.address.country string

Country
phone
 data.address.phone string

Phone
email
 data.address.email string

Email
company
 data.address.company string

Company
contact
 data.address.contact string

Contact

Lots

Operation ID:
Lot

List Lots

Parameters

Name Key Required Type Description
Location
 location string

Inventory at given location
Archived
 archived string

Archived
Status
 status string

Expired, Recalled, Neither
Limit
 limit integer

Max records to return, default 10

Returns

Name Path Type Description
count
 count integer

The number of Lots Returned
totalCount
 totalCount integer

The number of Matching Lots
data
 data array of object
id
 data.id integer

Lot ID
starred
 data.starred integer

Starred
syncToken
 data.syncToken integer

sync token
number
 data.number string

Lot Number
id
 data.item.id integer

Associated Item ID
name
 data.item.name string

Associated Item Name
description
 data.description string

Lot Description
expiration
 data.expiration date

Expiration Date
recalled
 data.recalled boolean

recalled
expired
 data.expired boolean

expired
customFields
 data.customFields array of object

Custom Fields
id
 data.customFields.id integer

ID
name
 data.customFields.name string

Name
value
 data.customFields.value string

Value
dataType
 data.customFields.dataType string

Data Type
onhand
 data.onhand number

On Hand
available
 data.available number

Available
summaryOnly
 data.summaryOnly boolean

Summary Only

Update Pick ticket

Operation ID:
UpdatePickTicket

Updates a specific pick ticket by setting the values of the parameters passed.

Parameters

Name Key Required Type Description
id
 id True integer

Pick Ticket ID to update
id
 id integer

Pick Ticket ID
starred
 starred integer
closed
 closed boolean
syncToken
 syncToken integer
number
 number string

Pick Ticket Number
date
 date string

Date Pick Ticket Created/Edited
id
 id integer

Customer ID
name
 name string

Customer Name
id
 id integer

Location ID
name
 name string

Location Name
id
 id integer

Channel ID
name
 name string

Channel Name
id
 id integer

Priority ID
name
 name string

Priority Name
id
 id integer

Assigned to User ID
name
 name string

Assigned to User Name
id
 id integer

Shipping Method ID
name
 name string

Shipping Method Name
trackingNumber
 trackingNumber string
id
 id integer

Linked Transaction id
transactionType
 transactionType string

Linked Transaction type
refNumber
 refNumber string

Linked Transaction Ref Number
linenumber
 linenumber integer

Linked Transaction Line Number
comment
 comment string

Pick Ticket Comment
customerNotes
 customerNotes string
id
 id integer

Custom Field ID
name
 name string

Custom Field Name
value
 value string

Custom Field Value
dataType
 dataType string

Custom Field Data Type
pickBy
 pickBy date

Pick-by Date
total
 total integer
archived
 archived boolean
summaryOnly
 summaryOnly boolean
hasSignature
 hasSignature boolean
id
 id integer

Pick Ticket Line ID
lineNumber
 lineNumber integer

Pick Ticket Line Number
id
 id number

Line Item ID
name
 name string

Pick Ticket Line Item Name
class
 class string
id
 id number

Pick Ticket Job ID
name
 name string

Pick ticket Job Name
id
 id integer

Pick Ticket workcenter ID
name
 name string

Pick ticket Workcenter Name
taxable
 taxable boolean
id
 id integer

Pick Ticket TaxCode ID
name
 name string

Pick ticket Taxcode Name
description
 description string

Line Item Description
quantity
 quantity number

Line Item Quantity
weight
 weight number

Line Item weight
volume
 volume number

Line Item Volume
weightunit
 weightunit string
volumeunit
 volumeunit string
id
 id integer

UOM ID
name
 name string

UOM Name
id
 id integer

Lot ID
name
 name string

Lot Name

Returns

Body
pickticket

Definitions

salesorder

Name Path Type Description
id
 id number

Sales Order ID
starred
 starred number
syncToken
 syncToken number

Sales Order sync token
number
 number string

Sales Order Number
date
 date date-time

Sales Order Date
id
 customer.id number

Sales Order Customer ID
name
 customer.name string

Sales Order Customer Name
id
 location.id number

Sales Order Location ID
name
 location.name string

Sales Order Location Name
billing
 billing address
shipping
 shipping address
id
 terms.id number

Sales Order Terms ID
name
 terms.name string

Sales Order Terms Name
id
 salesRep.id number

Sales Order Sales Rep ID
name
 salesRep.name string

Sales Order Sales Rep Name
channel
 channel string

Sales Order Channel
id
 department.id number

Sales Order Department ID
name
 department.name string

Sales Order Department Name
priority
 priority string
assignedToUser
 assignedToUser string
orderStage
 orderStage string
taxCode
 taxCode string
currency
 currency string
serial
 serial string
linkedTransaction
 linkedTransaction string
linkedInvoices
 linkedInvoices array of
linkedShipments
 linkedShipments array of
transactionLocationQuickBooks
 transactionLocationQuickBooks string
exchangeRate
 exchangeRate number
customerMessage
 customerMessage string
statusMessage
 statusMessage string
comment
 comment string
customerNotes
 customerNotes string
customFields
 customFields string
customerPO
 customerPO string
depositPercent
 depositPercent number
depositAmount
 depositAmount number
subTotal
 subTotal number
discountPercent
 discountPercent number
discountAmount
 discountAmount number
taxPercent
 taxPercent number
taxAmount
 taxAmount number
shippingAmount
 shippingAmount number
total
 total number
discountTaxable
 discountTaxable boolean
shippingTaxable
 shippingTaxable boolean
dropShip
 dropShip boolean
closed
 closed boolean
archived
 archived boolean
summaryOnly
 summaryOnly boolean
hasSignature
 hasSignature boolean
earliestDueDate
 earliestDueDate date-time
statusLink
 statusLink string
keys
 keys string
values
 values string
lines
 lines array of object

Sales Order Lines
id
 lines.id number

Sales Order Line ID
lineNumber
 lines.lineNumber number

Sales Order Line Number
id
 lines.item.id number

Sales Order Line Item ID
name
 lines.item.name string

Sales Order Line Item Name
class
 lines.class string
job
 lines.job string
workcenter
 lines.workcenter string
taxable
 lines.tax.taxable boolean
taxCode
 lines.tax.taxCode string
linkedTransaction
 lines.linkedTransaction string
description
 lines.description string

Sales Order Line Item Description
quantity
 lines.quantity number

Sales Order Line Item Quantity
weight
 lines.weight number

Sales Order Line Item Weight
volume
 lines.volume number

Sales Order Line Item Volume
weightunit
 lines.weightunit string

Sales Order Line Item Weight Unit
volumeunit
 lines.volumeunit string

Sales Order Line Item Volume Unit
unitprice
 lines.unitprice number

Sales Order Line Item Unit Price
amount
 lines.amount number

Sales Order Line Item Amount
altAmount
 lines.altAmount number
picked
 lines.picked number

Sales Order Line Item Quantity Picked
shipped
 lines.shipped number

Sales Order Line Item Quantity Shipped
invoiced
 lines.invoiced number

Sales Order Line Item Quantity Invoiced
produced
 lines.produced number

Sales Order Line Item Quantity Produced
returned
 lines.returned number

Sales Order Line Item Quantity Returned
cost
 lines.cost number

Sales Order Line Item Cost
margin
 lines.margin number

Sales Order Line Item Margin
listPrice
 lines.listPrice number

Sales Order Line Item List Price
percentdiscount
 lines.percentdiscount number

Sales Order Line Item Percent Discount
duedate
 lines.duedate date-time

Sales Order Line Item Due Date
uom
 lines.uom number
bin
 lines.bin string
lot
 lines.lot string

Sales Order Line Item Lot
serials
 lines.serials string

pickticket

Name Path Type Description
id
 id integer

Pick Ticket ID
starred
 starred integer
closed
 closed boolean
syncToken
 syncToken integer
number
 number string

Pick Ticket Number
date
 date string

Date Pick Ticket Created/Edited
id
 customer.id integer

Customer ID
name
 customer.name string

Customer Name
id
 location.id integer

Location ID
name
 location.name string

Location Name
id
 channel.id integer

Channel ID
name
 channel.name string

Channel Name
id
 priority.id integer

Priority ID
name
 priority.name string

Priority Name
id
 assignedToUser.id integer

Assigned to User ID
name
 assignedToUser.name string

Assigned to User Name
id
 shippingMethod.id integer

Shipping Method ID
name
 shippingMethod.name string

Shipping Method Name
trackingNumber
 trackingNumber string
linkedTransaction
 linkedTransaction linkedtransaction
comment
 comment string

Pick Ticket Comment
customerNotes
 customerNotes string
customFields
 customFields array of object
id
 customFields.id integer

Custom Field ID
name
 customFields.name string

Custom Field Name
value
 customFields.value string

Custom Field Value
dataType
 customFields.dataType string

Custom Field Data Type
pickBy
 pickBy date

Pick-by Date
total
 total integer
archived
 archived boolean
summaryOnly
 summaryOnly boolean
hasSignature
 hasSignature boolean
lines
 lines array of object
id
 lines.id integer

Pick Ticket Line ID
lineNumber
 lines.lineNumber integer

Pick Ticket Line Number
id
 lines.item.id number

Line Item ID
name
 lines.item.name string

Pick Ticket Line Item Name
class
 lines.class string
id
 lines.job.id number

Pick Ticket Job ID
name
 lines.job.name string

Pick ticket Job Name
id
 lines.workcenter.id integer

Pick Ticket workcenter ID
name
 lines.workcenter.name string

Pick ticket Workcenter Name
taxable
 lines.tax.taxable boolean
id
 lines.tax.taxCode.id integer

Pick Ticket TaxCode ID
name
 lines.tax.taxCode.name string

Pick ticket Taxcode Name
description
 lines.description string

Line Item Description
quantity
 lines.quantity number

Line Item Quantity
weight
 lines.weight number

Line Item weight
volume
 lines.volume number

Line Item Volume
weightunit
 lines.weightunit string
volumeunit
 lines.volumeunit string
id
 lines.uom.id integer

UOM ID
name
 lines.uom.name string

UOM Name
id
 lines.lot.id integer

Lot ID
name
 lines.lot.name string

Lot Name

customer

Name Path Type Description
id
 id number

customer ID
starred
 starred integer
syncToken
 syncToken integer

Customer sync token
name
 name string

Customer Name
fullname
 fullname string

Customer's full name
id
 parent.id integer

Customer Parent ID
name
 parent.name string

Customer Parent Name
sublevel
 sublevel integer
email
 email string

Customer email
website
 website string

Customer website
phone
 phone string

Customer Company Phone
mobile
 mobile string

Customer Mobile Phone
altPhone
 altPhone string
fax
 fax string
companyName
 companyName string

Customer Company Name
title
 contact.title string

Customer Contact title
firstName
 contact.firstName string

Customer Contact First Name
lastName
 contact.lastName string

Customer Contact First Name
suffix
 contact.suffix string

Customer Contact Suffix
billing
 billing address
shipping
 shipping address
id
 terms.id integer

Customer terms id
name
 terms.name string

Customer terms name
id
 priceTier.id integer
name
 priceTier.name string
id
 paymentMethod.id integer

Payment Method ID
name
 paymentMethod.name string

Payment Method Name
id
 salesRep.id integer

Sales Rep ID
name
 salesRep.name string

Sales Rep Name
id
 customerType.id integer

Customer Type ID
name
 customerType.name string

Customer type name
resaleNumber
 resaleNumber string

Resale Number
contractorNumber
 contractorNumber string

Contractor Number
businessLicense
 businessLicense string

Business License
foundUsVia
 foundUsVia string
id
 currency.id integer

Currency ID
name
 currency.name string

Currency Name
taxable
 tax.taxable boolean
id
 tax.taxCode.id integer

Tax Code ID
name
 tax.taxCode.name string

Tax Code Name
creditHold
 creditHold boolean
billWithParent
 billWithParent boolean
lastSync
 lastSync string
syncMessage
 syncMessage string
notes
 notes string

Customer notes
customFields
 customFields array of object
id
 customFields.id integer

Customer Custom Field ID
name
 customFields.name string

Customer Custom Field Name
value
 customFields.value string

Customer Custom Field Value
dataType
 customFields.dataType string

Customer Custom Field Data Type
altAddresses
 altAddresses array of
archived
 archived boolean

Customer Archived
hasChildren
 hasChildren boolean

Customer Has Children
summaryOnly
 summaryOnly boolean

Customer summary only

linkedtransaction

Name Path Type Description
id
 id integer

Linked Transaction id
transactionType
 transactionType string

Linked Transaction type
refNumber
 refNumber string

Linked Transaction Ref Number
linenumber
 linenumber integer

Linked Transaction Line Number

address

Name Path Type Description
company
 company string
contact
 contact string
phone
 phone string
email
 email string
addressName
 addressName string
addressType
 addressType string
line1
 address.line1 string
line2
 address.line2 string
line3
 address.line3 string
line4
 address.line4 string
line5
 address.line5 string
city
 address.city string
stateProvince
 address.stateProvince string
postalCode
 address.postalCode string
country
 address.country string