Re: json parse

[Bart Maertens]

Hi David,

Have a look at transforms/json-input-nested-elements.hpl in the samples
project.
You'll need to read the different elements in separate JSON Input
transforms and merge those back together later on in your stream.

Regards,
Bart


On Tue, Mar 12, 2024 at 10:08 PM David McNeill <da...@mcpond.co.nz> wrote:

> Why does the json input parser get confused with this snip....
>
> Is there a doc or source details what json input gets up to? Which
> java function does it use?
>
> path:
> $.*.value.productPriceLevels.*.productPriceLevel.gstInclusiveAmount
>
> Error:We found 1 values for json path [$.*.value.productType], which
> is different that the number returned for path
> [$.*.value.productPriceLevels.*.productPriceLe
>
> The second * seems to make it spill over inot the field after the
> group productPriceLevels
>
>      "productPriceLevels": [
>        {
>          "activationStatus": "ACTIVE",
>          "gstExclusiveAmount": "50.0000",
>          "gstInclusiveAmount": "57.5000",
>          "productPriceLevel": {
>            "uuid": "c03a597e-4157-4c9a-b338-897d6992b785",
>            "name": "Retail"
>          },
>          "productQuantityBreaks": [
> ... more lines
>
> "productType": {
>        "uuid": "3d16c771-9809-451d-b2a2-9538b4d0ddd1",
>        "name": "2200 - Electrical"
>      },
>