API Download Format
Downloading MYOB data from ODBC WriteNow is simply a matter of
sending a GET request with your MYOB API Key to the following URL.
http://myobsync.accede.com.au/download/[TableName]/[Page]?[Options]&apikey=[Company API Key]
Data Formats:
The Data Format of a URL request determines which MYOB table is downloaded as well as the format it is downloaded in by a URL request. In the below table are all the MYOB Tables currently available for download by ODBC WriteNow and their Data format.
Sales Invoice Itemssales_invoice_item/csvsales_invoice_item/json
MYOB Online Table | Download in CSV Format | Download in JSON Format |
Account Budget | account_budget/csv/ | account_budget/json/ |
Account Budget Lines | account_budget_lines/csv/ | account_budget_lines/json/ |
Account Register | account_register/csv/ | account_register/json/ |
Accounting Properties | accounting_properties/csv/ | accounting_properties/json/ |
Activity | activity/csv/ | activity/json/ |
Activity Slip | activity_slip/csv/ | activity_slip/json/ |
Adjustment | adjustment/csv/ | adjustment/json/ |
Adjustment Lines | adjustment_lines/csv/ | adjustment_lines/json/ |
Calculate Discounts Fees | calculate_discounts_fees/csv/ | calculate_discounts_fees/json/ |
Calculate Discounts Fees Lines | calculate_discounts_fees_lines/csv/ | calculate_discounts_fees_lines/json/ |
Category | category/csv/ | category/json/ |
Category Register | category_register/csv/ | category_register/json/ |
Contact | contact/csv/ | contact/json/ |
Credit Refund | credit_refund/csv/ | credit_refund/json/ |
Credit Settlement | credit_settlement/csv/ | credit_settlement/json/ |
Credit Settlement Lines | credit_settlement_lines/csv/ | credit_settlement_lines/json/ |
Currency | currency/csv/ | currency/json/ |
Customer | customer/csv/ | customer/json/ |
Customer Payments | customer_payments/csv/ | customer_payments/json/ |
Customer Payments Lines | customer_payments_lines/csv/ | customer_payments_lines/json/ |
Deduction | deduction/csv/ | deduction/json/ |
Employee | employee/csv/ | employee/json/ |
Employee Payment Details | employee_payment_details/csv/ | employee_payment_details/json/ |
Employee Payment Details Lines | employee_payment_details_lines/csv/ | employee_payment_details_lines/json/ |
Employee Payroll Advice | employee_payroll_advice/csv/ | employee_payroll_advice/json/ |
Employee Payroll Advice Lines | employee_payroll_advice_lines/csv/ | employee_payroll_advice_lines/json/ |
Employee Payroll Details | employee_payroll_details/csv/ | employee_payroll_details/json/ |
Employee Standard Pay | employee_standard_pay/csv/ | employee_standard_pay/json/ |
Employee Standard Pay Lines | employee_standard_pay_lines/csv/ | employee_standard_pay_lines/json/ |
Employee Timesheet | employee_timesheet/csv/ | employee_timesheet/json/ |
Employee Timesheet Lines | employee_timesheet_lines/csv/ | employee_timesheet_lines/json/ |
Entitlement | entitlement/csv/ | entitlement/json/ |
Expense | expense/csv/ | expense/json/ |
Expense Lines | expense_lines/csv/ | expense_lines/json/ |
General Journal | general_journal/csv/ | general_journal/json/ |
General Journal Lines | general_journal_lines/csv/ | general_journal_lines/json/ |
Item Price Matrix | item_price_matrix/csv/ | item_price_matrix/json/ |
Item Price Matrix Lines | item_price_matrix_lines/csv/ | item_price_matrix_lines/json/ |
Job | job/csv/ | job/json/ |
Job Budget | job_budget/csv/ | job_budget/json/ |
Job Budget Lines | job_budget_lines/csv/ | job_budget_lines/json/ |
Job Register | job_register/csv/ | job_register/json/ |
Ledger Accounts | ledger_accounts/csv/ | ledger_accounts/json/ |
Linked Account | linked_account/csv/ | linked_account/json/ |
Payroll Category | payroll_category/csv/ | payroll_category/json/ |
Payroll Category Summary | payroll_category_summary/csv/ | payroll_category_summary/json/ |
Payroll Category Summary Lines | payroll_category_summary_lines/csv/ | payroll_category_summary_lines/json/ |
Personal | personal/csv/ | personal/json/ |
Products | products/csv/ | products/json/ |
Profit And Loss Summary | profit_and_loss_summary/csv/ | profit_and_loss_summary/json/ |
Profit And Loss Summary Lines | profit_and_loss_summary_lines/csv/ | profit_and_loss_summary_lines/json/ |
Purchase Bill Item | purchase_bill_item/csv/ | purchase_bill_item/json/ |
Purchase Bill Item Lines | purchase_bill_item_lines/csv/ | purchase_bill_item_lines/json/ |
Purchase Bill Professional | purchase_bill_professional/csv/ | purchase_bill_professional/json/ |
Purchase Bill Professional Lines | purchase_bill_professional_lines/csv/ | purchase_bill_professional_lines/json/ |
Purchase Bills | purchase_bills/csv/ | purchase_bills/json/ |
Purchase Order Item | purchase_order_item/csv/ | purchase_order_item/json/ |
Purchase Order Item Lines | purchase_order_item_lines/csv/ | purchase_order_item_lines/json/ |
Purchase Order Miscellaneous | purchase_order_miscellaneous/csv/ | purchase_order_miscellaneous/json/ |
Purchase Order Miscellaneous Lines | purchase_order_miscellaneous_lines/csv/ | purchase_order_miscellaneous_lines/json/ |
Purchase Order Professional | purchase_order_professional/csv/ | purchase_order_professional/json/ |
Purchase Order Professional Lines | purchase_order_professional_lines/csv/ | purchase_order_professional_lines/json/ |
Purchase Order Service | purchase_order_service/csv/ | purchase_order_service/json/ |
Purchase Order Service Lines | purchase_order_service_lines/csv/ | purchase_order_service_lines/json/ |
Purchase Orders | purchase_orders/csv/ | purchase_orders/json/ |
Record With Discounts And Fees | record_with_discounts_and_fees/csv/ | record_with_discounts_and_fees/json/ |
Record With Discounts And Fees Lines | record_with_discounts_and_fees_lines/csv/ | record_with_discounts_and_fees_lines/json/ |
Sales Invoice | sales_invoice/csv/ | sales_invoice/json/ |
Sales Invoice Item | sales_invoice_item/csv/ | sales_invoice_item/json/ |
Sales Invoice Item Lines | sales_invoice_item_lines/csv/ | sales_invoice_item_lines/json/ |
Sales Invoice Miscellaneous | sales_invoice_miscellaneous/csv/ | sales_invoice_miscellaneous/json/ |
Sales Invoice Miscellaneous Lines | sales_invoice_miscellaneous_lines/csv/ | sales_invoice_miscellaneous_lines/json/ |
Sales Invoice Professional | sales_invoice_professional/csv/ | sales_invoice_professional/json/ |
Sales Invoice Professional Lines | sales_invoice_professional_lines/csv/ | sales_invoice_professional_lines/json/ |
Sales Invoice Time Billing | sales_invoice_time_billing/csv/ | sales_invoice_time_billing/json/ |
Sales Invoice Time Billing Lines | sales_invoice_time_billing_lines/csv/ | sales_invoice_time_billing_lines/json/ |
Sales Order | sales_order/csv/ | sales_order/json/ |
Sales Order Item | sales_order_item/csv/ | sales_order_item/json/ |
Sales Order Item Lines | sales_order_item_lines/csv/ | sales_order_item_lines/json/ |
Sales Order Miscellaneous | sales_order_miscellaneous/csv/ | sales_order_miscellaneous/json/ |
Sales Order Miscellaneous Lines | sales_order_miscellaneous_lines/csv/ | sales_order_miscellaneous_lines/json/ |
Sales Order Professional | sales_order_professional/csv/ | sales_order_professional/json/ |
Sales Order Professional Lines | sales_order_professional_lines/csv/ | sales_order_professional_lines/json/ |
Sales Order Timebilling | sales_order_timebilling/csv/ | sales_order_timebilling/json/ |
Sales Order Timebilling Lines | sales_order_timebilling_lines/csv/ | sales_order_timebilling_lines/json/ |
Sales Quote | sales_quote/csv/ | sales_quote/json/ |
Sales Quote Item | sales_quote_item/csv/ | sales_quote_item/json/ |
Sales Quote Item Lines | sales_quote_item_lines/csv/ | sales_quote_item_lines/json/ |
Sales Quote Miscellaneous | sales_quote_miscellaneous/csv/ | sales_quote_miscellaneous/json/ |
Sales Quote Professional | sales_quote_professional/csv/ | sales_quote_professional/json/ |
Sales Quote Professional Lines | sales_quote_professional_lines/csv/ | sales_quote_professional_lines/json/ |
Sales Quote Service | sales_quote_service/csv/ | sales_quote_service/json/ |
Sales Quote Service Lines | sales_quote_service_lines/csv/ | sales_quote_service_lines/json/ |
Sales Quote Timebilling | sales_quote_timebilling/csv/ | sales_quote_timebilling/json/ |
Sales Quote Timebilling Lines | sales_quote_timebilling_lines/csv/ | sales_quote_timebilling_lines/json/ |
Sales Service Order | sales_service_order/csv/ | sales_service_order/json/ |
Sales Service Order Lines | sales_service_order_lines/csv/ | sales_service_order_lines/json/ |
Service Bill Lines | service_bill_lines/csv/ | service_bill_lines/json/ |
Service Bills | service_bills/csv/ | service_bills/json/ |
Service Order | service_order/csv/ | service_order/json/ |
Service Order Lines | service_order_lines/csv/ | service_order_lines/json/ |
Service Purchase | service_purchase/csv/ | service_purchase/json/ |
Service Purchase Lines | service_purchase_lines/csv/ | service_purchase_lines/json/ |
Service Sales | service_sales/csv/ | service_sales/json/ |
Service Sales Lines | service_sales_lines/csv/ | service_sales_lines/json/ |
Statement | statement/csv/ | statement/json/ |
Superannuation | superannuation/csv/ | superannuation/json/ |
Superannuation Fund | superannuation_fund/csv/ | superannuation_fund/json/ |
Superannuation Lines | superannuation_lines/csv/ | superannuation_lines/json/ |
Supplier | supplier/csv/ | supplier/json/ |
Supplier Payment | supplier_payment/csv/ | supplier_payment/json/ |
Supplier Payment Lines | supplier_payment_lines/csv/ | supplier_payment_lines/json/ |
Tax | tax/csv/ | tax/json/ |
Tax Code | tax_code/csv/ | tax_code/json/ |
Tax Code Summary | tax_code_summary/csv/ | tax_code_summary/json/ |
Tax Code Summary Lines | tax_code_summary_lines/csv/ | tax_code_summary_lines/json/ |
Tax Table | tax_table/csv/ | tax_table/json/ |
Transaction Coding Summary | transaction_coding_summary/csv/ | transaction_coding_summary/json/ |
Transaction Journal | transaction_journal/csv/ | transaction_journal/json/ |
Transaction Journal Lines | transaction_journal_lines/csv/ | transaction_journal_lines/json/ |
Transactions | transactions/csv/ | transactions/json/ |
Wage | wage/csv/ | wage/json/ |
Wage Lines | wage_lines/csv/ | wage_lines/json/ |
Paging
Depending on the API Call, MYOB Online only returns a maximum of 1000 records, to get around this ODBC WriteNow uses the Pages system.
The Pages system splits the total records for a MYOB table into pages of 400 records.
For example requesting ODBC WriteNow to view the 3rd page will skip the first 800 records and get records 801 to 1200.
The Page value goes just after the Data format in the URL call, this value is must be an Integer i.e 4,6,7.
The Paging count starts from 0. Page 0 contains records 1-400, Page 2 contains 401-800 etc.
http://myobsync.accede.com.au/download/job/csv/2=true&apikey=[YourAPIkey]
Additional Options
Only Header
[onlyheader] Allows users to request only the table headings for the selected MYOB table without any records, this can be used to review the MYOB table name or confirm that a value is located in the selected MYOB table.
[onlyheader] can be used by including “onlyheader=true” at the end of a URL call, as shown below.
http://myobsync.accede.com.au/download/job/csv/0?onlyheader=true&apikey=[YourAPIkey]
Date From
[datefrom] allows users to specify a certain date that they want to receive records from. When [datefrom] is added to a URL call ODBC WriteNow will ONLY return records with dates AFTER the given date.
[datefrom] will have not effect if the called MYOB table does not have a valid date field, e.g. the Customers table. [datefrom] can be used by including “datefrom=2016-12-30” at the end of a URL call, as shown below.
http://myobsync.accede.com.au/download/job/csv/0?datefrom=2016-12-30&apikey=[YourAPIkey]
Number Filtering
[number] filter allows filtering on the data that comes from MYOB.
Currently it’s only support on
Products |
http://myobsync.accede.com.au/download/products/csv/0?number=INV1230&apikey=[YourAPIkey]