I am new to PDO. Anyway, when I do, an Ajax call, I am getting data into an associative array, but when I try to JSON_encode, to return to AJAX, it does NOT appear to do it correctly. Not sure why. I have tried looking through the forum, but all answers that were posted didn't work. I have tried using almost every fetch type to no avail.
$results = $conn->prepare($s); //prepare the query for execution
$data = array();
if (!$results) {
echo "false"; //No Results have been returned
}
else {
echo "Generating Results Set for query.";
$results->execute([$f, $t]); // Execute query with the two parameters start date & End date
// PULL THE RESULTS WITH FETCH
while ($resultset = $results->fetch()) {
$data['data'] = $resultset;
header('Content-Type: application/json');
// file_put_contents( 'C:\temp\debugD' . time() . '.log', PHP_EOL . $resultset[0] .", "
.$resultset[1] ,FILE_APPEND); // writes out two columns
file_put_contents( 'C:\temp\debugD' . time() . '.log', var_export($data, true),
FILE_APPEND); // Writes out and array
$json= json_encode($data, JSON_FORCE_OBJECT);
file_put_contents( 'C:\temp\debugE' . time() . '.log', var_export($json, true),
FILE_APPEND); // Writes out JSON but needs tweaked
}
}
$conn = null;
Exit;
}
Outputting the below array:
**array (
'data' =>
array (
'ProductCode' => '1113489',
0 => '1113489',
'ProductDescription' => 'DOUBLEBASE GEL 500G',
1 => 'DOUBLEBASE GEL 500G',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900051',
4 => 'S_900051',
'CostPrice' => '21.8700',
5 => '21.8700',
'ProdAreaIdentifier1Id' => 'SKC',
6 => 'SKC',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '39.6900',
10 => '39.6900',
),
)array (
'data' =>
array (
'ProductCode' => '1113491',
0 => '1113491',
'ProductDescription' => 'AHS GEL HAND SANITISER',
1 => 'AHS GEL HAND SANITISER',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900072',
4 => 'S_900072',
'CostPrice' => '5.4000',
5 => '5.4000',
'ProdAreaIdentifier1Id' => 'FA',
6 => 'FA',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '9.9500',
10 => '9.9500',
),
)array (
'data' =>
array (
'ProductCode' => '1113492',
0 => '1113492',
'ProductDescription' => 'light up sports yoyo',
1 => 'light up sports yoyo',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '.4900',
5 => '.4900',
'ProdAreaIdentifier1Id' => 'CHIL',
6 => 'CHIL',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '1.5000',
10 => '1.5000',
),
)array (
'data' =>
array (
'ProductCode' => '1113493',
0 => '1113493',
'ProductDescription' => 'unicorn light up unicorn',
1 => 'unicorn light up unicorn',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '.4900',
5 => '.4900',
'ProdAreaIdentifier1Id' => 'CHIL',
6 => 'CHIL',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '1.5000',
10 => '1.5000',
),
)array (
'data' =>
array (
'ProductCode' => '1113494',
0 => '1113494',
'ProductDescription' => 'PURSE €6.50',
1 => 'PURSE €6.50',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900091',
4 => 'S_900091',
'CostPrice' => '2.7700',
5 => '2.7700',
'ProdAreaIdentifier1Id' => 'ACC',
6 => 'ACC',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '6.5000',
10 => '6.5000',
),
)array (
'data' =>
array (
'ProductCode' => '1113495',
0 => '1113495',
'ProductDescription' => 'LUNA 3 IN 1 BRUSH',
1 => 'LUNA 3 IN 1 BRUSH',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900105',
4 => 'S_900105',
'CostPrice' => '8.1000',
5 => '8.1000',
'ProdAreaIdentifier1Id' => 'COS',
6 => 'COS',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '15.0000',
10 => '15.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113496',
0 => '1113496',
'ProductDescription' => 'LUNA VOLUME SHAMPOO',
1 => 'LUNA VOLUME SHAMPOO',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900104',
4 => 'S_900104',
'CostPrice' => '6.5000',
5 => '6.5000',
'ProdAreaIdentifier1Id' => 'HAI',
6 => 'HAI',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '12.0000',
10 => '12.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113497',
0 => '1113497',
'ProductDescription' => 'LUNA VOLUME CONDITIONER',
1 => 'LUNA VOLUME CONDITIONER',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900105',
4 => 'S_900105',
'CostPrice' => '6.5000',
5 => '6.5000',
'ProdAreaIdentifier1Id' => 'HAI',
6 => 'HAI',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '12.0000',
10 => '12.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113499',
0 => '1113499',
'ProductDescription' => 'LUNA VOLUME FOAM',
1 => 'LUNA VOLUME FOAM',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900105',
4 => 'S_900105',
'CostPrice' => '7.7500',
5 => '7.7500',
'ProdAreaIdentifier1Id' => 'HAI',
6 => 'HAI',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '14.0000',
10 => '14.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113500',
0 => '1113500',
'ProductDescription' => 'breathe right nasal strips',
1 => 'breathe right nasal strips',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900051',
4 => 'S_900051',
'CostPrice' => '4.8200',
5 => '4.8200',
'ProdAreaIdentifier1Id' => 'OTC',
6 => 'OTC',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '8.7500',
10 => '8.7500',
),
)array (
'data' =>
array (
'ProductCode' => '1113501',
0 => '1113501',
'ProductDescription' => 'OVELLE CALAMINE LOTION',
1 => 'OVELLE CALAMINE LOTION',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900038',
4 => 'S_900038',
'CostPrice' => '3.1100',
5 => '3.1100',
'ProdAreaIdentifier1Id' => 'OTC',
6 => 'OTC',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '5.6400',
10 => '5.6400',
),
)array (
'data' =>
array (
'ProductCode' => '1113502',
0 => '1113502',
'ProductDescription' => 'calpol saline nasal drops',
1 => 'calpol saline nasal drops',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900038',
4 => 'S_900038',
'CostPrice' => '2.7500',
5 => '2.7500',
'ProdAreaIdentifier1Id' => 'OTC',
6 => 'OTC',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '4.9900',
10 => '4.9900',
),
)array (
'data' =>
array (
'ProductCode' => '1113503',
0 => '1113503',
'ProductDescription' => 'FROZEN GIRLS PYJAMAS',
1 => 'FROZEN GIRLS PYJAMAS',
'BaseCurrencyTaxCode' => '0',
2 => '0',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '4.9200',
5 => '4.9200',
'ProdAreaIdentifier1Id' => 'CHIL',
6 => 'CHIL',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '10.0000',
10 => '10.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113504',
0 => '1113504',
'ProductDescription' => 'clear cosmetic bags',
1 => 'clear cosmetic bags',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '.8400',
5 => '.8400',
'ProdAreaIdentifier1Id' => 'ACC',
6 => 'ACC',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '2.0000',
10 => '2.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113505',
0 => '1113505',
'ProductDescription' => 'hot water bottles printed logo',
1 => 'hot water bottles printed logo',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '3.0800',
5 => '3.0800',
'ProdAreaIdentifier1Id' => 'FOS',
6 => 'FOS',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '8.0000',
10 => '8.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113506',
0 => '1113506',
'ProductDescription' => 'BUGGY TOY',
1 => 'BUGGY TOY',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '1.3400',
5 => '1.3400',
'ProdAreaIdentifier1Id' => 'BAB',
6 => 'BAB',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '3.0000',
10 => '3.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113507',
0 => '1113507',
'ProductDescription' => 'MARBLE RUN GAME',
1 => 'MARBLE RUN GAME',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '3.3300',
5 => '3.3300',
'ProdAreaIdentifier1Id' => 'CHIL',
6 => 'CHIL',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '8.0000',
10 => '8.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113508',
0 => '1113508',
'ProductDescription' => 'TRACK RACING SET',
1 => 'TRACK RACING SET',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '2.8000',
5 => '2.8000',
'ProdAreaIdentifier1Id' => 'CHIL',
6 => 'CHIL',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '6.5000',
10 => '6.5000',
),
)array (
'data' =>
array (
'ProductCode' => '1113509',
0 => '1113509',
'ProductDescription' => 'FLOATING BATH TOYS',
1 => 'FLOATING BATH TOYS',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '.8900',
5 => '.8900',
'ProdAreaIdentifier1Id' => 'BAB',
6 => 'BAB',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '3.0000',
10 => '3.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113510',
0 => '1113510',
'ProductDescription' => 'LADIES BED SOCKS WITH GRIPPERS',
1 => 'LADIES BED SOCKS WITH GRIPPERS',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '.8900',
5 => '.8900',
'ProdAreaIdentifier1Id' => 'LAD',
6 => 'LAD',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '2.0000',
10 => '2.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113511',
0 => '1113511',
'ProductDescription' => 'SLIME GUSH BALLS',
1 => 'SLIME GUSH BALLS',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '2.4600',
5 => '2.4600',
'ProdAreaIdentifier1Id' => 'CHIL',
6 => 'CHIL',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '5.0000',
10 => '5.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113512',
0 => '1113512',
'ProductDescription' => 'LADIES CHRISTMAS SLIPPER SOCKS',
1 => 'LADIES CHRISTMAS SLIPPER SOCKS',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '2.8000',
5 => '2.8000',
'ProdAreaIdentifier1Id' => 'LAD',
6 => 'LAD',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '5.0000',
10 => '5.0000',
),
)array (
'data' =>
array (
'ProductCode' => '1113513',
0 => '1113513',
'ProductDescription' => 'CHRISTMAS NOVELTY GLASSES',
1 => 'CHRISTMAS NOVELTY GLASSES',
'BaseCurrencyTaxCode' => '1',
2 => '1',
'ManufUniqueId' => NULL,
3 => NULL,
'DefSrcClientNumber' => 'S_900089',
4 => 'S_900089',
'CostPrice' => '.7800',
5 => '.7800',
'ProdAreaIdentifier1Id' => 'chris',
6 => 'chris',
'ProdAreaIdentifier2Id' => 'NU',
7 => 'NU',
'ProdAreaIdentifier3Id' => 'NU',
8 => 'NU',
'Additional1' => NULL,
9 => NULL,
'UNITprice' => '2.0000',
10 => '2.0000',
),
)**
debugE - AFTER THE JSON_ENCODE OUTPUTTING BELOW RESULT
*'{"data":{"ProductCode":"1113489","0":"1113489","ProductDescription":"DOUBLEBASE GEL 500G","1":"DOUBLEBASE GEL 500G","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900051","4":"S_900051","CostPrice":"21.8700","5":"21.8700","ProdAreaIdentifier1Id":"SKC","6":"SKC","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"39.6900","10":"39.6900"}}''{"data":{"ProductCode":"1113491","0":"1113491","ProductDescription":"AHS GEL HAND SANITISER","1":"AHS GEL HAND SANITISER","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900072","4":"S_900072","CostPrice":"5.4000","5":"5.4000","ProdAreaIdentifier1Id":"FA","6":"FA","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"9.9500","10":"9.9500"}}''{"data":{"ProductCode":"1113492","0":"1113492","ProductDescription":"light up sports yoyo","1":"light up sports yoyo","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":".4900","5":".4900","ProdAreaIdentifier1Id":"CHIL","6":"CHIL","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"1.5000","10":"1.5000"}}''{"data":{"ProductCode":"1113493","0":"1113493","ProductDescription":"unicorn light up unicorn","1":"unicorn light up unicorn","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":".4900","5":".4900","ProdAreaIdentifier1Id":"CHIL","6":"CHIL","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"1.5000","10":"1.5000"}}'false'{"data":{"ProductCode":"1113495","0":"1113495","ProductDescription":"LUNA 3 IN 1 BRUSH","1":"LUNA 3 IN 1 BRUSH","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900105","4":"S_900105","CostPrice":"8.1000","5":"8.1000","ProdAreaIdentifier1Id":"COS","6":"COS","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"15.0000","10":"15.0000"}}''{"data":{"ProductCode":"1113496","0":"1113496","ProductDescription":"LUNA VOLUME SHAMPOO","1":"LUNA VOLUME SHAMPOO","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900104","4":"S_900104","CostPrice":"6.5000","5":"6.5000","ProdAreaIdentifier1Id":"HAI","6":"HAI","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"12.0000","10":"12.0000"}}''{"data":{"ProductCode":"1113497","0":"1113497","ProductDescription":"LUNA VOLUME CONDITIONER","1":"LUNA VOLUME CONDITIONER","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900105","4":"S_900105","CostPrice":"6.5000","5":"6.5000","ProdAreaIdentifier1Id":"HAI","6":"HAI","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"12.0000","10":"12.0000"}}''{"data":{"ProductCode":"1113499","0":"1113499","ProductDescription":"LUNA VOLUME FOAM","1":"LUNA VOLUME FOAM","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900105","4":"S_900105","CostPrice":"7.7500","5":"7.7500","ProdAreaIdentifier1Id":"HAI","6":"HAI","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"14.0000","10":"14.0000"}}''{"data":{"ProductCode":"1113500","0":"1113500","ProductDescription":"breathe right nasal strips","1":"breathe right nasal strips","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900051","4":"S_900051","CostPrice":"4.8200","5":"4.8200","ProdAreaIdentifier1Id":"OTC","6":"OTC","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"8.7500","10":"8.7500"}}''{"data":{"ProductCode":"1113501","0":"1113501","ProductDescription":"OVELLE CALAMINE LOTION","1":"OVELLE CALAMINE LOTION","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900038","4":"S_900038","CostPrice":"3.1100","5":"3.1100","ProdAreaIdentifier1Id":"OTC","6":"OTC","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"5.6400","10":"5.6400"}}''{"data":{"ProductCode":"1113502","0":"1113502","ProductDescription":"calpol saline nasal drops","1":"calpol saline nasal drops","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900038","4":"S_900038","CostPrice":"2.7500","5":"2.7500","ProdAreaIdentifier1Id":"OTC","6":"OTC","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"4.9900","10":"4.9900"}}''{"data":{"ProductCode":"1113503","0":"1113503","ProductDescription":"FROZEN GIRLS PYJAMAS","1":"FROZEN GIRLS PYJAMAS","BaseCurrencyTaxCode":"0","2":"0","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":"4.9200","5":"4.9200","ProdAreaIdentifier1Id":"CHIL","6":"CHIL","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"10.0000","10":"10.0000"}}''{"data":{"ProductCode":"1113504","0":"1113504","ProductDescription":"clear cosmetic bags","1":"clear cosmetic bags","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":".8400","5":".8400","ProdAreaIdentifier1Id":"ACC","6":"ACC","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"2.0000","10":"2.0000"}}''{"data":{"ProductCode":"1113505","0":"1113505","ProductDescription":"hot water bottles printed logo","1":"hot water bottles printed logo","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":"3.0800","5":"3.0800","ProdAreaIdentifier1Id":"FOS","6":"FOS","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"8.0000","10":"8.0000"}}''{"data":{"ProductCode":"1113506","0":"1113506","ProductDescription":"BUGGY TOY","1":"BUGGY TOY","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":"1.3400","5":"1.3400","ProdAreaIdentifier1Id":"BAB","6":"BAB","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"3.0000","10":"3.0000"}}''{"data":{"ProductCode":"1113507","0":"1113507","ProductDescription":"MARBLE RUN GAME","1":"MARBLE RUN GAME","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":"3.3300","5":"3.3300","ProdAreaIdentifier1Id":"CHIL","6":"CHIL","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"8.0000","10":"8.0000"}}''{"data":{"ProductCode":"1113508","0":"1113508","ProductDescription":"TRACK RACING SET","1":"TRACK RACING SET","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":"2.8000","5":"2.8000","ProdAreaIdentifier1Id":"CHIL","6":"CHIL","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"6.5000","10":"6.5000"}}''{"data":{"ProductCode":"1113509","0":"1113509","ProductDescription":"FLOATING BATH TOYS","1":"FLOATING BATH TOYS","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":".8900","5":".8900","ProdAreaIdentifier1Id":"BAB","6":"BAB","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"3.0000","10":"3.0000"}}''{"data":{"ProductCode":"1113510","0":"1113510","ProductDescription":"LADIES BED SOCKS WITH GRIPPERS","1":"LADIES BED SOCKS WITH GRIPPERS","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":".8900","5":".8900","ProdAreaIdentifier1Id":"LAD","6":"LAD","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"2.0000","10":"2.0000"}}''{"data":{"ProductCode":"1113511","0":"1113511","ProductDescription":"SLIME GUSH BALLS","1":"SLIME GUSH BALLS","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":"2.4600","5":"2.4600","ProdAreaIdentifier1Id":"CHIL","6":"CHIL","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"5.0000","10":"5.0000"}}''{"data":{"ProductCode":"1113512","0":"1113512","ProductDescription":"LADIES CHRISTMAS SLIPPER SOCKS","1":"LADIES CHRISTMAS SLIPPER SOCKS","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":"2.8000","5":"2.8000","ProdAreaIdentifier1Id":"LAD","6":"LAD","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"5.0000","10":"5.0000"}}''{"data":{"ProductCode":"1113513","0":"1113513","ProductDescription":"CHRISTMAS NOVELTY GLASSES","1":"CHRISTMAS NOVELTY GLASSES","BaseCurrencyTaxCode":"1","2":"1","ManufUniqueId":null,"3":null,"DefSrcClientNumber":"S_900089","4":"S_900089","CostPrice":".7800","5":".7800","ProdAreaIdentifier1Id":"chris","6":"chris","ProdAreaIdentifier2Id":"NU","7":"NU","ProdAreaIdentifier3Id":"NU","8":"NU","Additional1":null,"9":null,"UNITprice":"2.0000","10":"2.0000"}}'*