Does Yellowfin have any JSON test files we can use?

We have created a few hundred thousand individual JSON files for testing the JSON connector. The data set is retail music store data.

We can generate up to 12 Million individual files.

For any customers who are testing the FTP or S3 processing of the JSON connector, we would be happy to share these JSON files with you, just send a request to support for 'SAMPLE JSON Stores Files" and we will organize the transfer via our FTP service.

One Sample Below

{
"BASKET": {
"StoreID": 100000007,
"Latitude": -28.8105030000,
"PostCode": "2480",
"State": "NSW",
"Longitude": 153.2747520000,
"Suburb": "LISMORE",
"StoreName": "LISMORE",
"Street": "CONWAY STREET",
"OpenHoursSun": "Closed",
"OpenHoursMon": "08:30 - 17:00",
"OpenHoursTue": "08:30 - 17:00",
"OpenHoursWed": "08:30 - 17:00",
"OpenHoursThur": "08:30 - 17:00",
"OpenHoursFri": "08:30 - 17:00",
"OpenHoursSat": "Closed",
"paymentRecord": {
"StoreID": 100000007,
"AuditDateTime": "Mar 27, 2014 2:58:50 PM",
"TillId": "5",
"Receipt": "05/40269",
"CounterId": "05",
"CashTendered": 0.00,
"EftposTendered": 69.00,
"PaySeq": "40269",
"SysSeq": 132817,
"Rounding": 0.00,
"saleList": [{
"StoreID": 100000007,
"SKU": "50218000",
"DateTimeSold": "Mar 28, 2014 1:58:23 AM",
"TillId": "5",
"Reversal": 0,
"Receipt": "05/40269",
"CounterId": "05",
"Quantity": 1,
"SaleAmount": 69.00,
"PaySeq": "40269",
"LineNbr": 1,
"GSTIndicator": "*",
"TaxCode": "S1",
"PrimaryRef": "",
"Stock_Artist": "Era",
"Stock_Category": 2,
"Stock_Genre": 0,
"Stock_SupplierId": 4,
"Stock_ReleaseYear": "1998",
"Stock_PriceStrategy": 2,
"Stock_AlbumName": "Era",
"Stock_SKUCost": 9.50,
"Stock_SKUList": 19.00,
"Stock_Composer": "",
"Stock_TrackName": "",
"Stock_ArtistName": "Era",
"PriceStrategy_PriceStrategyDesc": "Discount",
"Supplier_SupplierName": "RCA"
}]
}
}
}

Is this article helpful?
0 0 0