AnsweredAssumed Answered

Split Document by JSON Profile Element?

Question asked by PatrickBrilino6911 on Sep 6, 2016
Latest reply on Sep 6, 2016 by PatrickBrilino6911

I'm trying to split the JSON document below based on the QuoteLineId, but it's not splitting correctly.  Here is the JSON data:

 

{
"DealInfo": {
"OpptyId": "0063200001lNn0y",
"SFDCSONum": "SO-020862",
"QuoteNumber": "Q-124804",
"Contracted" : "true"
},
"Lines": [{
"QuoteLineId": "a2o32000002IDTl",
"SOLineId": "a34320000005MbFAAU",
"ShipDate": "2016-08-26",
"EndDate": "2017-08-26",
"CreateAssets": "false",
"CreateLicenses": "true",
"Qty": "5"
}, {
"QuoteLineId": "a2o32000002IDTg",
"SOLineId": "a34320000005MbK",
"ShipDate": "2016-08-26",
"EndDate": "2099-08-26",
"CreateAssets": "false",
"CreateLicenses": "false",
"Qty": "5"
}, {
"QuoteLineId": "a2o32000002IDThAAO",
"SOLineId": "a34320000005MbBAAU",
"ShipDate": "2016-08-26",
"EndDate": "2099-08-26",
"CreateAssets": "true",
"CreateLicenses": "false",
"Qty": "5"
}]
}

 

And here is my JSON profile:

JSON Profile

 

I tried splitting by the QuoteLineId, which is unique.  I also tried splitting by the ArrayElement and the Array, but each time the split only returns one document instead of three. Batch count is set to "0" for the split step.  I originally created the JSON profile by importing the sample data above, so the profile should be accurate.

 

Anything I should be looking out for?  Any help is greatly appreciated!

Outcomes