Forum Discussion

Richard's avatar
Richard
New Contributor III
4 years ago

Some json strings questions

Hi We are just starting off with SnapLogic and we wonder if somebody can give us some answers to the following questions. We have the following input [ { transactionId:“F59AE026-8AEA-4F69-B...
expression_language
sample_pipeline
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago
Copy Link

Hey @vcocco,

The sample data provided is incorrect. First, it’s not properly formatted. While posting data samples or expressions, you should always use the “Preformatted text” option.

Second, the Keys in JSON should always be in double quotes, and values to, if they are string of course. You can read more about JSON on the following link:

JSON W3Schools

But as a contrast for better understanding, I formatted the same sample in the right format:

[
	{
		"transactionId": "F59AE026-8AEA-4F69-BE97-F7AB981AC3BF",
		"LineCreationSequenceNumber": 1,
		"ItemNumber": "99999999991",
		"OrderedSalesQuantity": 1,
		"SalesPrice": 120,
		"AVAPromotionCode": null,
		"SalesUnitSymbol": "UN",
		"SalesProductCategoryName": null,
		"AVALaserText": null,
		"AVAWrappingText": null,
		"original": {
			"erpOrderNumber": "JEM-99999",
			"clientOrderNumber": "00118204"
		}
	},
	{
		"transactionId": "F59AE026-8AEA-4F69-BE97-F7AB981AC3BF",
		"LineCreationSequenceNumber": 2,
		"ItemNumber": "99999999994",
		"OrderedSalesQuantity": 2,
		"SalesPrice": 80.93,
		"AVAPromotionCode": null,
		"SalesUnitSymbol": "UN",
		"SalesProductCategoryName": null,
		"AVALaserText": null,
		"AVAWrappingText": null,
		"original": {
			"erpOrderNumber": "JEM-99999",
			"clientOrderNumber": "00118205"
		}
	}
]