Relation between two JSON data sources

[alex-leslie]

I’m currently designing a report in the desktop designer which has two JSON datasources. The first is the primary record detail, the second has some lookup display values.

I have to create a relation between the two data source, so that when the report is generated the display text from the second data source is displayed for a certain property, rather than the ID that’s stored in the primary record. but it looks like it’s not possible? In the relation window it does not have the json properties to select, only the index, item and array properties.

If it’s not possible with the relation, could this be done via scripting? I’ve not been able to work out how to iterate the array of items on the datasource

thanks in advance for any help!