Here's the format of the data i have been working on. i've tried using INDEXED_EXTRACTIONS=JSON in props but the event data is lesser than expected.
{
"d": {
"results": [{
"__metadata": {
"id": "http://sapuri('123456789')",
"uri": "sapuri('123456789')",
"type": "sapuri"
},
"DATETIME": "05/05/2016 18:34:40",
"System_ID": "DE1",
"Client_ID": "200",
"SO_Datetime": "05/05/2016 18:34:40",
"SO_Number": "123456789",
"SO_Item": "000010",
"SO_Type": "ANOR",
"PO_Num": "",
"Sales_Organization": "NP01",
"Distribution_Channel": "01",
"Division": "01",
"Sales_Office": "",
"Sales_Group": "",
"Delivery_Block": "",
"Requested_Delivery_Date": "05/05/2016",
"Order_Reason": "301",
"Header_Net_Value": " 100.00",
"Currency": "USD",
"Product_Number": "000000000000123456",
"Product_Description": "sample-product description",
"Order_Quantity": " 1.000",
"Sales_Unit": "DOS",
"Item_Net_Value": " 100.00",
"Cost_Value": " 0.00",
"Tax_Value": " 7.00",
"Rejection_Code": "",
"Billing_Block": "",
"Pricing_Procedure": "SAMPLE",
"PO_Type": "SAMP",
"Cust_Material": "",
"Item_Category": "SAMP",
"Delivery_Quantity": "0.000 ",
"Confirmed_Quantity": "1.000 ",
"Plant": "7001",
"Customer_Number": "2000010281",
"Address_Code": "0002429053",
"Customer_Name": "abcdefghijklmnop",
"House_Number": "",
"Street": "qrstuvwxyz",
"City": "MIAMI",
"Region": "FL",
"Country_Code": "US",
"Post_Code": "33586-2008",
"Status_Txt": "Billed",
"Status_ID": "4",
"DN_Number": "",
"DN_Item": "",
"DN_Date": "",
"DN_Item_Date": "",
"DN_Material_Num": "",
"DN_Quantity": "",
"DN_Werks": "",
"DN_Point": "",
"DN_Type": "",
"DN_Route": "",
"DN_Bill_Lading": "",
"DN_Shipping_Date": "",
"DN_Ext_Delivery_Num": "",
"DN_Route_Schedule": "",
"DN_Billing_Date": "",
"Bill_Doc": "8123456727",
"Bill_Item": "123410",
"Bill_Fiscal_Year": "0000",
"Bill_Company_Code": "2250",
"Bill_Sales_Org": "AB01",
"Bill_Dist_Channel": "01",
"Bill_Quantity": "1.000 ",
"Bill_Sales_Unit": "DOS",
"Bill_Material_Num": "00123456000102970",
"Bill_Type": "aNF1",
"Bill_Date": "12/05/2016",
"Bill_Createdate": "05/05/2016 18:38:56",
"Bill_Item_date": "05/05/2016 18:38:56",
"Bill_Net_Value": "300.00 ",
"Bill_Payer": "4000014278",
"Bill_Sold_To_Party": "2000010281",
"Bill_Cancelled": "",
"Bill_Ref_Doc": "123457178913",
"Bill_Sales_Doc": "11235678113",
"Bill_Plant": "7001",
"Bill_Item_Net_Value": "100.00 ",
"Accounting_Number": ""
}
]
}
}
... View more