Order Table Extraction
Last updated
Last updated
In this example, we are a company that sells many different products. Our customer sends us a small table of all the items they want to buy. However, since the customer creates the table, it can look slightly different every time. For example, they write Product ID instead of product_id
, Qty
instead of Quantity
, and the shipping times have no clear structure.
TZX22-EHZ2
100
2.76$
Tusp
1-2 days
ZUI23-772L6
250
5.00$
-
1 week
UIUU-13BMW
340'000
0.001$
puma
About a month
QUE2-AIME2
56
45.56$
lebra
Tomorrow
Waveline Extract makes it easy to unify these fields into one format we define.
Let's construct a to extract product_id
, unit_price
, quantity
, and shipping_time
for each product:
As we can see above, all the fields have successfully been unified into the format we defined!
We can now call the endpoint with this shape and the table as the payload to create the job:
After some time, we query for the result of this job with the endpoint and get the following in the result
field: