Ondigital
About usCase StudiesLoginSign up
Logo for Ongoing WMS
BigQuery Connector
70 / month

Ongoing WMS

Pricing calculatorCreate account

Ongoing WMS Goods Owner REST API (orders, order lines, and more).

Guide / Information

Enter warehouse name, API username/password and Goods Owner ID. Then select which tables to export in the datasource config.

Available fields
Date fields

Created date

Delivery date

Shipped date

Printed date

Delivery date

Created date

Article data last updated

Article created date

Snapshot date

Invoice date

Period start

Period end

Action date

In date

Created date

Arrival time

Created date

In date

Created date

In date

Created date

Metric fields

Order status number

Customer price

Freight price

Tracking freight price

Ordered items

Picked items

Allocated items

Ordered items

Allocated items

Picked items

Packed items

Returned items

Line price

Customer line price

Discount %

Weight

Volume

Purchase price

Stock valuation price

Customer price

Stock qty

Booked qty

Sellable qty

Number of items

Locked items

Sellable items

Available for sale

Allocated items

Invoice amount

Price

Number of items

Status number

Returned items

Picked items

To be returned

Status number

Row price

Advised items

Received items

Reported items

Dimension fields

Order ID

Order number

Goods owner order ID

Reference number

Consignee order number

Order status

Order type

Way of delivery

Tracking freight currency

Tracking URL

Waybill

Return waybill

Service point code

Warehouse code

Warehouse name

Transporter code

Transporter name

Transporter service code

Consignee customer number

Consignee name

Consignee city

Consignee post code

Consignee country

Consignee email

Marketplace

Marketplace order number

Order remark

Free text 1

Free text 2

Free text 3

Invoice URL

Order ID

Order number

Line ID

Row number

External line ID

Article system ID

Article number

Article name

Customer article number

Currency

VAT code

Line type

Batch number

Serial number

Comment

Article system ID

Article number

Article name

Product code

Unit code

Description

Is stock article

Is active

Article kind

Purchase currency

Country of origin

Statistics number

Article group

Article category

Article system ID

Article number

Warehouse ID

Invoice ID

Invoice number

Title

Is exported

Your order number

Your reference

Charge ID

Invoice ID

Invoice number

Comment

Invoice article code

Invoice article title

Order ID

Order number

Profit center code

Profit center name

Return order ID

Return order number

Comment

Status

Warehouse code

Warehouse name

Customer order ID

Customer order number

Handling comment

Return line ID

Return order ID

Return order number

Row number

Article system ID

Article number

Article name

Return cause

Purchase order ID

Purchase order number

Supplier order number

Goods owner reference

Reference number

Status

Type code

Remark

Warehouse code

Warehouse name

Supplier number

Supplier name

Invoice number

Goods owner PO ID

PO line ID

Purchase order ID

Purchase order number

Row number

Article system ID

Article number

Article name

Comment

Batch number

* We'll add more fields on request 👏