View source for Web API Examples

https://Server1/Sample_Company/TCustomer<br> 

{<br> "tcustomer":[<br> {<br> "href":"http\/\/Server1\/erpapi\/tcustomer\/1",<br> "ID":1,<br> "msTimeStamp":"2010-10-02 01:31:15",<br> "ClientName":"Cash Customer",<br> "GlobalRef":"DEF1"<br> },<br> {<br> "href":"http\/\/Server1\/erpapi\/tcustomer\/2",<br> "ID":2,<br> "msTimeStamp":"2011-07-13 10:08:42",<br> "ClientName":"Workshop",<br> "GlobalRef":"DEF2"<br> },<br> {<br> "href":"http\/\/Server1\/erpapi\/tcustomer\/3",<br> "ID":3,<br> "msTimeStamp":"2011-07-13 10:08:42",<br> "ClientName":"Apple Corp",<br> "GlobalRef":"DEF3"<br> },<br> {<br> "href":"http\/\/Server1\/erpapi\/tcustomer\/5",<br> "ID":5,<br> "msTimeStamp":"2011-11-22 19:37:10",<br> "ClientName":"Mr Smith",<br> "GlobalRef":"DEF5" <br> 

<br> 

https://Server1/erpapi/TCustomer/5<br> 

{<br> "type":"TCustomer",<br> "fields":<br> {<br> "ABN":"",<br> "Active":true,<br> "Altcontact":"",<br> "AltPhone":"",<br> "ARBalance":60,<br> "Area":0,<br> "AssessorsName":"",<br> "BailmentAmountEx":0,<br> "BailmentNumber":"",<br> "Balance":60,<br> "BankAccountBSB":"",<br> "BankAccountName":"",<br> "BankAccountNo":"",<br> "BankCode":"",<br> "Billcountry":"Australia",<br> "BillingAddress":"87 Nerang Street\r\nGOLDEN BEACH VIC 3851\r\nAustralia",<br> "BillingAddressWithName":"Mr Smith\r\n87 Nerang Street\r\nGOLDEN BEACH VIC 3851\r\nAustralia",<br> "BillPostcode":"3851",<br> "BillState":"VIC",<br> "BillStreet":"87 Nerang Street",<br> "BillStreet2":"",<br> "BillStreet3":"",<br> "Billsuburb":"GOLDEN BEACH",<br> "BodyType":"",<br> "CallPriority":5,<br> "CardNumber":"",<br> "ClientAddress":"Mr Smith\r\n87 Nerang Street\r\nGOLDEN BEACH VIC 3851\r\nAustralia",<br> "ClientDetails":"Mr Joe Smith\r\nMr Smith\r\n87 Nerang Street\r\nGOLDEN BEACH VIC 3851\r\nAustralia",<br> "ClientName":"Mr Smith",<br> "ClientNo":"",<br> "ClientTypeName":"Default",<br> "Colour":"",<br> "Contacts":[<br> {<br> "type":"TContact",<br> "fields":<br> {<br> "AccountNo":"",<br> "Active":true,<br> "CardNumber":"",<br> "Company":"John Smith",<br> "ContactAddress":"87 Nerang Street",<br> "ContactAddress2":"",<br> "ContactAddress3":"",<br> "ContactAltPH":"",<br> "ContactCity":"GOLDEN BEACH",<br> "ContactCountry":"",<br> "ContactEmail":"",<br> "ContactFax":"0755658978",<br> "ContactFirstName":"John",<br> "ContactMOB":"",<br> "ContactPcode":"3851",<br> "ContactPH":"0755987856",<br> "ContactState":"VIC",<br> "ContactSurName":"Smith",<br> "ContactTitle":"",<br> "CustomerName":"Mr Smith",<br> "EmployeeName":"",<br> "GlobalRef":"DEF59",<br> "ID":59,<br> "IsPrimaryContact":false,<br> "JobName":"",<br> "JobTitle":"",<br> "MsTimeStamp":"2011-08-03 10:15:51",<br> "Notes":"",<br> "OtherContactName":"",<br> "SupplierName":"",<br> "TeamviewerID":"",<br> "UseOnRun":false<br> }<br> },<br> {<br> "type":"TContact",<br> "fields":<br> {<br> "AccountNo":"",<br> "Active":true,<br> "CardNumber":"",<br> "Company":"Mr Smith",<br> "ContactAddress":"87 Nerang Street",<br> "ContactAddress2":"",<br> "ContactAddress3":"",<br> "ContactAltPH":"",<br> "ContactCity":"GOLD COAST MC",<br> "ContactCountry":"",<br> "ContactEmail":"",<br> "ContactFax":"0755658978",<br> "ContactFirstName":"Joe",<br> "ContactMOB":"0142545878",<br> "ContactPcode":"9727",<br> "ContactPH":"0755987856",<br> "ContactState":"QLD",<br> "ContactSurName":"Smith",<br> "ContactTitle":"Mr",<br> "CustomerName":"Mr Smith",<br> "EmployeeName":"",<br> "GlobalRef":"DEF46",<br> "ID":46,<br> "IsPrimaryContact":true,<br> "JobName":"",<br> "JobTitle":"",<br> "MsTimeStamp":"2010-09-01 20:41:53",<br> "Notes":"",<br> "OtherContactName":"",<br> "SupplierName":"",<br> "TeamviewerID":"",<br> "UseOnRun":false<br> }<br> }],<br> "Country":"Australia",<br> "CreditBalance":803.5,<br> "CreditLimit":2000,<br> "CUSTDATE1":"",<br> "CUSTFLD3":"",<br> "CUSTFLD4":"",<br> "CustomerNextInvoiceNo":1,<br> "CustomfieldValues":null,<br> "DefaultClassName":"",<br> "DefaultContactMethod":"",<br> "DeliveryNotes":"",<br> "DischargeDate":"",<br> "Discount":0,<br> "DontContact":false,<br> "Email":"",<br> "EmailXML":"",<br> "ExcessAmount":0,<br> "Faxnumber":"0755658978",<br> "FinalDestination":"",<br> "FirstName":"Joe",<br> "ForcePONumOnInvoice":false,<br> "ForcePOOnBooking":false,<br> "ForcePOOnRepair":false,<br> "ForeignExchangeCode":"AUD",<br> "GlobalRef":"DEF5",<br> "GracePeriod":5,<br> "GroupDiscountOverridesAll":false,<br> "hours":0,<br> "ID":5,<br> "IncoPlace":"",<br> "InvoiceComment":"",<br> "InvoiceCommentPopUp":false,<br> "IsCustomer":true,<br> "IsOtherContact":false,<br> "IsSupplier":false,<br> "LastName":"Smith",<br> "ManufactureName":"",<br> "Mobile":"0142545878",<br> "Model":null,<br> "MsTimeStamp":"2011-11-22 19:37:10",<br> "NewOrUsed":"",<br> "Notes":"",<br> "OtherFollowUps":null,<br> "ParentClientName":"",<br> "ParentRelatedClientName":"",<br> "PaymentMethodName":"",<br> "Phone":"0755987856",<br> "PhonesupportTill":"",<br> "PickingPriority":5,<br> "POComment":"",<br> "POCommentPopup":false,<br> "PortOfDischarge":"",<br> "PortOfLanding":"",<br> "Postcode":"3851",<br> "ProductGroupDiscount":null,<br> "RelatedCustomers":null,<br> "RepName":"John Citizen",<br> "RewardPointsExpireDate":"",<br> "RewardPointsOpeningBalance":0,<br> "RewardPointsOpeningDate":"",<br> "SalesOrderBalance":743.5,<br> "ShippingAgentCode":"",<br> "ShippingMethodName":"",<br> "ShipToAddress":"Mr Smith\r\n87 Nerang Street\r\nGOLDEN BEACH VIC 3851",<br> "SkypeName":"",<br> "SourceName":"Radio",<br> "SpecialDiscount":0,<br> "SpecialProductPriceOverridesAll":false,<br> "SpecialProducts":null,<br> "State":"VIC",<br> "StockReceivedDate":0,<br> "StopCredit":false,<br> "StormDate":"",<br> "StormLocation":"",<br> "Street":"87 Nerang Street",<br> "Street2":"",<br> "Street3":"",<br> "StreetAddress":"87 Nerang Street\r\nGOLDEN BEACH VIC 3851\r\nAustralia",<br> "StreetAddressWithName":"Mr Smith\r\n87 Nerang Street\r\nGOLDEN BEACH VIC 3851\r\nAustralia",<br> "Suburb":"GOLDEN BEACH",<br> "TaxCodeName":"",<br> "TeamviewerID":"",<br> "TermsName":"EOM",<br> "Title":"Mr",<br> "URL":"",<br> "UseCustomerInvoiceNo":false,<br> "Year":""<br> }<br>}<br> 

<br> 

https://Server1/Sample_Company/TInvoice<br> 

{<br> "type":"TInvoice",<br> "fields":<br> {<br> "GLAccountName":"Accounts Receivable",<br> "CustomerName":"4X4 World",<br> "TermsName":"COD",<br> "EmployeeName":"Admin .",<br> "SaleClassName":"Default",<br> "SaleDate":"2012-02-27",<br> "ShipToDesc":"XYZ Pty Ltd\r\n12 Mud Drive\r\nROTTNEST ISLAND WA 6161\r\nAustralia",<br> "Lines":[<br> {<br> "type":"TInvoiceLine",<br> "fields":<br> {<br> "ProductName":"MatrixXSRed",<br> "UnitOfMeasure":"Units",<br> "UOMQtySold":2,<br> "LinePrice":10,<br> "LineTaxCode":"GST",<br> "LinePriceInc":11,<br> "TotalLineAmount":20,<br> "TotalLineAmountInc":22<br> }<br> },<br> {<br> "type":"TInvoiceLine",<br> "fields":<br> {<br> "ProductName":"MatrixSmlRed",<br> "UnitOfMeasure":"Units",<br> "UOMQtySold":1,<br> "LinePrice":10,<br> "LineTaxCode":"GST",<br> "LinePriceInc":11,<br> "TotalLineAmount":10,<br> "TotalLineAmountInc":11<br> }<br> }],<br> "Comments":"This is comment line one\r\nand this is comment line two.",<br> "TotalAmount":30,<br> "TotalAmountInc":33<br> }<br>}<br><br> 

https://Server1/Sample_Company/TInvoice/1768<br> 

{<br> "type":"TInvoice",<br> "fields":<br> {<br> "AddToManifest":false,<br> "AmountDue":0,<br> "ApplyFlag":false,<br> "ARNotes":"",<br> "AutoSmartOrderRef":"",<br> "BackOrderGlobalRef":"",<br> "BarcodePickingDone":false,<br> "BaseNo":"",<br> "BlindBalancePeriodID":0,<br> "Cancelled":false,<br> "ChequeNumber":"",<br> "CleanContributionAmount":0,<br> "ClientName":"4X4 World",<br> "Comments":"This is comment line one\r\nand this is comment line two.",<br> "CommissionPaid":false,<br> "ConNote":"",<br> "ContactName":"",<br> "ContributionAmount":0,<br> "Converted":false,<br> "CreationDate":"2012-02-27 00:00:00",<br> "CustomerName":"4X4 World",<br> "CustPONumber":"",<br> "Deleted":false,<br> "Deposited":false,<br> "DocNumber":"1768",<br> "DueDate":"2012-02-27 00:00:00",<br> "EarlyPaymentDiscountAmount":0,<br> "EmployeeName":"Admin .",<br> "EnteredAt":"12:34:53 PM",<br> "EnteredBy":"Web User",<br> "ForeignBalanceAmount":0,<br> "ForeignExchangeCode":"AUD",<br> "ForeignExchangeRate":1,<br> "ForeignPaidAmount":0,<br> "ForeignTotalAmount":0,<br> "GLAccountName":"Accounts Receivable",<br> "GlobalRef":"DEF1768",<br> "HoldSale":true,<br> "ID":1768,<br> "InvoicePrintDesc":"",<br> "InvoiceToDesc":"4X4 World\r\n12 Mud Drive\r\nROTTNEST ISLAND WA 6161\r\nAustralia",<br> "IsBarcodePicking":false,<br> "IsInternalOrder":false,<br> "IsManifest":false,<br> "IsPaid":false,<br> "Lines":[<br> {<br> "type":"TInvoiceLine",<br> "fields":<br> {<br> "Active":true,<br> "AssetAccount":"",<br> "Attrib1Sale":0,<br> "Attrib1SaleRate":0,<br> "Attrib2Sale":0,<br> "AutoSmartOrder":false,<br> "BaseLineGlobalRef":"",<br> "BOQty":2,<br> "CalcGrossProfitPercentInc":0,<br> "CalcProfit":0,<br> "CalcProfitEx":0,<br> "CalcProfitPercent":0,<br> "CalcProfitPercentEx":0,<br> "CogsAccount":"",<br> "CreationDate":"",<br> "CustomData":"",<br> "Deleted":false,<br> "DiscountAmount":0,<br> "DiscountPercent":0,<br> "DocketNumber":"F",<br> "FESalesLines":null,<br> "ForeignExchangeCode":"",<br> "ForeignExchangeRate":0,<br> "ForeignHedgingUsed":false,<br> "ForeignLinePrice":11,<br> "ForeignTotalLineAmount":0,<br> "FormulaID":0,<br> "GlobalRef":"DEF2637",<br> "GrossProfitbasedLatestCostPercentInc":100,<br> "GrossProfitPercentInc":100,<br> "ID":2637,<br> "IncomeAccount":"",<br> "Invoiced":false,<br> "IsFormulaRElatedProduct":false,<br> "IsQuote":false,<br> "IsRelatedProduct":false,<br> "LatestCostPrice":0,<br> "LatestCostPriceInc":0,<br> "LaybyId":"0",<br> "LineCost":0,<br> "LineCostInc":0,<br> "LineNotes":"",<br> "LinePrice":10,<br> "LinePriceInc":11,<br> "LineTaxCode":"GST",<br> "LineTaxRate":0.1,<br> "LineTaxTotal":0,<br> "MarkupAmount":0,<br> "MarkupPercent":0,<br> "MatrixDesc":"",<br> "MatrixPrice":0,<br> "MatrixRef":"",<br> "MemoLine":"",<br> "MsTimeStamp":"2012-02-27 12:34:54",<br> "OrderQty":2,<br> "OriginalLinePrice":10,<br> "ParentProductName":"",<br> "PartBarcode":"",<br> "PartSpecID":0,<br> "PQA":null,<br> "ProductDescription":"",<br> "ProductGroup":"",<br> "ProductName":"MatrixXSRed",<br> "ProductType":"",<br> "Product_Description":"",<br> "Product_Description_Memo":"",<br> "Profit":20,<br> "ProfitbasedLatestCost":20,<br> "ProfitbasedLatestCostInc":22,<br> "ProfitbasedLatestCostPercent":100,<br> "ProfitbasedLatestCostPercentInc":100,<br> "ProfitInc":22,<br> "ProfitPercent":100,<br> "ProfitPercentInc":100,<br> "ProgressPaymentRef":"",<br> "Qty":0,<br> "QtyBackOrder":2,<br> "QtyShipped":0,<br> "QtySold":2,<br> "RefundQty":0,<br> "RelatedParentLineRef":"",<br> "RelatedProductQty":0,<br> "SalesLinesCustField1":"",<br> "SalesLinesCustField10":"",<br> "SalesLinesCustField2":"",<br> "SalesLinesCustField3":"",<br> "SalesLinesCustField4":"",<br> "SalesLinesCustField5":"",<br> "SalesLinesCustField6":"",<br> "SalesLinesCustField7":"",<br> "SalesLinesCustField8":"",<br> "SalesLinesCustField9":"",<br> "SeqNo":1,<br> "SerialNumbers":"",<br> "ShipDate":"2012-02-27 00:00:00",<br> "SmartOrderCreated":false,<br> "SoldSerials":"",<br> "SortID":10,<br> "SpecDescription":"",<br> "SpecValue":"0",<br> "SupplierName":"",<br> "TimeCostUsed":false,<br> "TotalLineAmount":0,<br> "TotalLineAmountInc":0,<br> "TransDate":"2012-02-27 00:00:00",<br> "UnitOfMeasure":"Units",<br> "UOMMultiplier":1,<br> "UOMNameProductKey":"Units:",<br> "UOMOrderQty":2,<br> "UOMQty":0,<br> "UOMQtyBackOrder":2,<br> "UOMQtyShipped":0,<br> "UOMQtySold":2,<br> "WarrantyEndsOn":"",<br> "WarrantyPeriod":""<br> }<br> },<br> {<br> "type":"TInvoiceLine",<br> "fields":<br> {<br> "Active":true,<br> "AssetAccount":"",<br> "Attrib1Sale":0,<br> "Attrib1SaleRate":0,<br> "Attrib2Sale":0,<br> "AutoSmartOrder":false,<br> "BaseLineGlobalRef":"",<br> "BOQty":1,<br> "CalcGrossProfitPercentInc":0,<br> "CalcProfit":0,<br> "CalcProfitEx":0,<br> "CalcProfitPercent":0,<br> "CalcProfitPercentEx":0,<br> "CogsAccount":"",<br> "CreationDate":"",<br> "CustomData":"",<br> "Deleted":false,<br> "DiscountAmount":0,<br> "DiscountPercent":0,<br> "DocketNumber":"F",<br> "FESalesLines":null,<br> "ForeignExchangeCode":"",<br> "ForeignExchangeRate":0,<br> "ForeignHedgingUsed":false,<br> "ForeignLinePrice":11,<br> "ForeignTotalLineAmount":0,<br> "FormulaID":0,<br> "GlobalRef":"DEF2638",<br> "GrossProfitbasedLatestCostPercentInc":100,<br> "GrossProfitPercentInc":100,<br> "ID":2638,<br> "IncomeAccount":"",<br> "Invoiced":false,<br> "IsFormulaRElatedProduct":false,<br> "IsQuote":false,<br> "IsRelatedProduct":false,<br> "LatestCostPrice":0,<br> "LatestCostPriceInc":0,<br> "LaybyId":"0",<br> "LineCost":0,<br> "LineCostInc":0,<br> "LineNotes":"",<br> "LinePrice":10,<br> "LinePriceInc":11,<br> "LineTaxCode":"GST",<br> "LineTaxRate":0.1,<br> "LineTaxTotal":0,<br> "MarkupAmount":0,<br> "MarkupPercent":0,<br> "MatrixDesc":"",<br> "MatrixPrice":0,<br> "MatrixRef":"",<br> "MemoLine":"",<br> "MsTimeStamp":"2012-02-27 12:34:54",<br> "OrderQty":1,<br> "OriginalLinePrice":10,<br> "ParentProductName":"",<br> "PartBarcode":"",<br> "PartSpecID":0,<br> "PQA":null,<br> "ProductDescription":"",<br> "ProductGroup":"",<br> "ProductName":"MatrixSmlRed",<br> "ProductType":"",<br> "Product_Description":"",<br> "Product_Description_Memo":"",<br> "Profit":10,<br> "ProfitbasedLatestCost":10,<br> "ProfitbasedLatestCostInc":11,<br> "ProfitbasedLatestCostPercent":100,<br> "ProfitbasedLatestCostPercentInc":100,<br> "ProfitInc":11,<br> "ProfitPercent":100,<br> "ProfitPercentInc":100,<br> "ProgressPaymentRef":"",<br> "Qty":0,<br> "QtyBackOrder":1,<br> "QtyShipped":0,<br> "QtySold":1,<br> "RefundQty":0,<br> "RelatedParentLineRef":"",<br> "RelatedProductQty":0,<br> "SalesLinesCustField1":"",<br> "SalesLinesCustField10":"",<br> "SalesLinesCustField2":"",<br> "SalesLinesCustField3":"",<br> "SalesLinesCustField4":"",<br> "SalesLinesCustField5":"",<br> "SalesLinesCustField6":"",<br> "SalesLinesCustField7":"",<br> "SalesLinesCustField8":"",<br> "SalesLinesCustField9":"",<br> "SeqNo":2,<br> "SerialNumbers":"",<br> "ShipDate":"2012-02-27 00:00:00",<br> "SmartOrderCreated":false,<br> "SoldSerials":"",<br> "SortID":20,<br> "SpecDescription":"",<br> "SpecValue":"0",<br> "SupplierName":"",<br> "TimeCostUsed":false,<br> "TotalLineAmount":0,<br> "TotalLineAmountInc":0,<br> "TransDate":"2012-02-27 00:00:00",<br> "UnitOfMeasure":"Units",<br> "UOMMultiplier":1,<br> "UOMNameProductKey":"Units:",<br> "UOMOrderQty":1,<br> "UOMQty":0,<br> "UOMQtyBackOrder":1,<br> "UOMQtyShipped":0,<br> "UOMQtySold":1,<br> "WarrantyEndsOn":"",<br> "WarrantyPeriod":""<br> }<br> }],<br> "MedType":"",<br> "Memo":"",<br> "MsTimeStamp":"2012-02-27 12:34:54",<br> "NoOfBoxes":0,<br> "OrderNumber":"",<br> "OriginalDocNumber":"DEF1768",<br> "PayDueDate":"",<br> "PayMethod":"",<br> "PickMemo":"",<br> "PickupFromDesc":"",<br> "PlannedDeliveryFrom":"",<br> "PlannedDeliveryTo":"",<br> "POCreated":false,<br> "POSPostCode":"",<br> "PrintedAt":"",<br> "PrintedBy":"",<br> "PrintedOn":"",<br> "PrintFlag":false,<br> "PrintHold":false,<br> "QuoteGlobalRef":"",<br> "RepairGlobalRef":"",<br> "RepairID":0,<br> "SaleClassName":"Default",<br> "SaleDate":"2012-02-27 00:00:00",<br> "SaleDateTime":"2012-02-27 00:00:00",<br> "SalesCategory":"",<br> "SalesOrderGlobalRef":"",<br> "SalesStatus":"",<br> "ShipDate":"2012-02-27 00:00:00",<br> "Shipping":"",<br> "ShippingCost":0,<br> "ShipToDesc":"XYZ Pty Ltd\r\n12 Mud Drive\r\nROTTNEST ISLAND WA 6161\r\nAustralia",<br> "ShipToID":0,<br> "SOProgressPaymentGlobalRef":"",<br> "SOProgressPaymentOriginalRef":"",<br> "TermsName":"COD",<br> "TillID":1,<br> "TillName":"",<br> "TimeOfSale":"",<br> "TotalAmount":0,<br> "TotalAmountInc":0,<br> "TotalAttrib1Sale":0,<br> "TotalAttrib1SaleRate":0,<br> "TotalAttrib2Sale":0,<br> "TotalBalance":0,<br> "TotalCost":0,<br> "TotalDiscount":0,<br> "TotalMarkup":0,<br> "TotalPaid":0,<br> "TotalQtyBackOrdered":0,<br> "TotalQuoteAmount":0,<br> "TotalQuoteAmtInc":0,<br> "TotalTax":0,<br> "TotalWEGTax":0,<br> "TotalWETTax":0,<br> "UsedOnManifest":false,<br> "UseWholesalePrice":false<br> }<br>}<br><br><br>