eRep API

RetrieveSchema

Get the table schema required to prepare import JSON.

Request

URI Parameters

None.

Body Parameters

None.

Sample API Request

GET api/OrderDetail/RetrieveSchema

api/OrderDetail/RetrieveSchema

Response

Resource Description

Returns the success/error status along with requested table schema.

ResponseMessage

Name	Description	Type	Additional information
Status	The status of the request, namely Success or Error.	MessageStatus	None.
Message	The response message containing either message or requested data.	string	None.

Sample API Response

GET api/OrderDetail/RetrieveSchema

[{ "Status":1, "Message": "[ {"OrderStateID":"Int Mandatory"}, {"EntityID":"Int Mandatory"}, {"CurrencyID":"Int Mandatory"}, {"RefOrderDetailID":"Int Optional"}, {"LineItemID":"Int Optional"}, {"OrderLineNumber":"Int Optional"}, {"ItemID":"String(255) Optional"}, {"ItemUPCCode":"String(12) Optional"}, {"SerialNumber":"String(50) Optional"}, {"Description":"String(255) Optional"}, {"OrderQty":"Int Mandatory"}, {"ItemUOM":"String(15) Optional"}, {"ItemWeight":"Double(53,0) Optional"}, {"DiscountPerc":"Double(53,0) Mandatory"}, {"Taxable":"Bool Mandatory"}, {"ItemCost":"Decimal(19,4) Mandatory"}, {"ItemUnitPrice":"Decimal(19,4) Mandatory"}, {"TaxGroupID":"String(36) Optional"}, {"TaxAmount":"Decimal(19,4) Optional"}, {"TaxPercent":"Double(53,0) Optional"}, {"SubTotal":"Decimal(19,4) Mandatory"}, {"Total":"Decimal(19,4) Mandatory"}, {"TotalCost":"Decimal(19,4) Mandatory"}, {"TotalWeight":"Double(53,0) Optional"}, {"TrackingNumber":"String(50) Optional"}, {"WarehouseBinZone":"String(36) Optional"}, {"ScheduledStartDate":"DateTime Optional"}, {"ScheduledEndDate":"DateTime Optional"}, {"ServiceStartDate":"DateTime Optional"}, {"ServiceEndDate":"DateTime Optional"}, {"DetailMemo1":"String(255) Optional"}, {"DetailMemo2":"String(255) Optional"}, {"DetailMemo3":"String(255) Optional"}, {"DetailMemo4":"String(255) Optional"}, {"DetailMemo5":"String(255) Optional"}, {"ItemLongDescription":"String(1000) Optional"}, {"Notes":"String(-1) Optional"}, {"ItemTag":"String(-1) Optional"}, {"ItemModel":"String(50) Optional"}, {"ItemModelSize":"String(50) Optional"}, {"ListAdds":"Decimal(19,4) Mandatory"}, {"IsAccessory":"Bool Mandatory"}, {"ListPrice":"Decimal(19,4) Optional"}, {"LineItemTypeID":"Int Optional"}, {"CostAdds":"Decimal(19,4) Mandatory"} ]" }]

<- Back to Help Page Home