API Upload Format

Sending data to MYOB via ODBC WriteNow is simply a matter of sending the data formatted into a certain style to the following upload URL and include the data in the correct format for the MYOB Table you want to import to.

http://myobsync.accede.com.au/sync/post?apikey=[YourAPIkey]

Uploadable File Examples

When uploading data via ODBC WriteNow the data must be formatted into a certain way to correctly import into ODBC WriteNow. Below are examples of the current uploaded file types for each MYOB table in ODBC WriteNow, simply click on any of the file names to see the data details you can and need to enter.

Requirements:

  • File Encoding: UTF-8
  • File name does not matter, The Style field controls what the data is

File Formats:

Style=Indivual (Required)
Lastname=Hill4 (Required)
Firstname=Craig4 (Required)
Street=104A Gibson St
City=Bowden
State=SA
Postcode=5007
Phone1=
Phone2=0401297505
Notes=Test Customer
CurrentBalance=1000
UseCustomerTaxCode=True
Label=AZZ
Lvalue=B

SaleLayout=Service
PrintedForm=Test Form
InvoiceDelivery=Nothing
ItemPriceLevel=Level A
ReceiptMemo=Testing Memo
ShippingMethod=Air
SaleComment=This is a testing comment
HourlyBillingRate=10
ABN=45 676 343 223
ABNBranch=014
TaxIdNumber=5555
Memo=Test Memo
PaymentIsDue=PrePaid
DiscountDate=10
BalanceDueDate=50
DiscountForEarlyPayment=25
MonthlyChargeForLatePayment=30
VolumeDiscount=0
Limit=1000
Available=1000
PastDue=0
OnHold=False

Method=Visa
CardNumber=1234
NameOnCard=Matthew Cogswell
BSBNumber=
BankAccountNumber=98765
BankAccountName=Matt's Account
Notes=This is a test Card

Style=Company (Required)
Companyname=Accede (Required)
Street=104A Gibson St
City=Bowden
State=SA
Postcode=5007
Phone1=
Phone2=0401297505
Notes=Test Customer
CurrentBalance=1000
UseCustomerTaxCode=True
Label=AZZ
Lvalue=B

SaleLayout=Service
PrintedForm=Test Form
InvoiceDelivery=Nothing
ItemPriceLevel=Level A
ReceiptMemo=Testing Memo
ShippingMethod=Air
SaleComment=This is a testing comment
HourlyBillingRate=10
ABN=45 676 343 223
ABNBranch=014
TaxIdNumber=5555
Memo=Test Memo
PaymentIsDue=PrePaid
DiscountDate=10
BalanceDueDate=50
DiscountForEarlyPayment=25
MonthlyChargeForLatePayment=30
VolumeDiscount=0
Limit=1000
Available=1000
PastDue=0
OnHold=False

Method=Visa
CardNumber=1234
NameOnCard=Matthew Cogswell
BSBNumber=
BankAccountNumber=98765
BankAccountName=Matt's Account
Notes=This is a test Card

Style=Job (Required)
Number=65579 (Required)
Name=Accede
Header=D
Description=Test2
Startdate=4/5/2016
FinishDate=24/5/2016
JobName=Testing Job
Contact=Matthew Cogswell
Manager=Chris Chase
PercentComplete=50
IsActive=False
TrackReimbursables=True
Style=ServiceOrder (Required)
CompanyName=Hill, Craig (Required)
CustomersNumber=62130 (Required)
Date=4/5/2016 (Required)
JobNumber=62130 (Required)
Description=Guttering as per Contract(Required)
AccountDisplayID=4-0100 (Required)
Taxcode=GST (Required)
IsTaxInclusive=True (Required)
Total=3324.56 (Required)
Freight=500
FreightTaxCode=GST
Comment=Testing Comment
PromisedDate=20/5/2016
ShippingMethod=Air
ReferralSource=Advertisement
JournalMemo=Sale; New Fields Test
DeliveryStatus=PrintAndEmail
PaymentIsDue=PrePaid
DiscountDate=1
BalanceDueDate=30
DiscountForEarlyPayment=5
MonthlyChargeForLatePayment=7
DiscountExpiryDate=7/06/2016
Discount=5
DueDate=7/06/2016
FinanceCharge=6.08

Style=Supplier (Required)
Companyname=Accede Holdings (Required)
ABN=12345678910
Street=Innovation House, 50 Mawson Lakes Boulevard 
City=Mawson Lakes
State=SA
Postcode=5127
Phone1=
Phone2=

Style=ServicePurchase (Required)
Date=2/10/2016 (Required)
CompanyName=Cash Purchases (Required)
InvoiceNumber=01027884
IsTaxInclusive=TRUE
SupplierNumber=738
FreightTaxcode=GST
JobNumber=IML611785
Description=""
AccountDisplayID=5-6552
Taxcode=GST
Total=709.5

Style=ServiceSales (Required)
Date=30/9/2016 (Required)
CompanyName=Accede (Required)
InvoiceNumber=01013734
IsTaxInclusive=TRUE
CustomersNumber=1013734
SalesPersonName= Cogswell, Matthew
JobNumber=IDO611816
Description="Test Description"
AccountDisplayID=4-1000
Taxcode=GST
Total=8100

Style=ItemSales (Required)
CompanyName=Accede Holdings (Required)
Date=17/09/2018 (Required)
ShipTo=Innovation House, 50 Mawson Lakes Boulevard
JournalMemo=Imported via ODBCWriteNow
Itemcode=LP1234;KM4321
Description="Lenova Laptop";"Keyboard and mouse set"
Quantity=1;1
Unitprice=500;100
Total=500;100
Taxcode=GST;GST