0

Select JSON Parent data

Hi all,

 

I am running into an issue with selecting JSON parent data. I have a Hubspot datasource with multiple versions of a deal that looks somewhat like this:

[{
dealID: xxxx
properties: {
versions: {
[{
dealstage: xxxx
}{
  dealstage: xxxx
}]
}
}
}{
dealID: xxxx
properties: {
versions: {
[{
dealstage: xxxx
}{
  dealstage: xxxx
}{
  dealstage: xxxx
}]
}
}
}]

What I need to do is align the dealID from the parent element with each dealstage value. This requires me to select parent elements, which I have tried to do using the '/..' notation, however this is simply returning blank values (@/properties/version/dealstage/../../../dealID). I also can't seem to get a repeat function to work, as there are a variable number of objects within the versions array.

Has anyone dealt with this before, any hints on how to tackle this?

 

Thanks

Chris

1 comment

Please sign in to leave a comment.