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