Sub-field value as variable identifier for the next storage

Created on 17 April 2024, 8 months ago
Updated 2 May 2024, 8 months ago

Can I use a the value of a field from source A as a variable in the URL of source B? And thus getting results not by a common identifier but rather from a value of an result from that common identifier.

So I have two sources where i get some data:

http://api/1/1055774 gives me a field $.id.serial with value a5h41d
I would like to use that value as the identifactor for the second source: thus: http://api/2/a5h41d
And then aggegrating the results from both sources.

I've been reading the docs over and over again, it seems possible, yet I'm not able to make it work. Or I could have misread.

Thanks

Feature request
Status

Postponed

Version

1.0

Component

Code

Created by

🇧🇪Belgium nabcomi

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @nabcomi
  • 🇫🇷France guignonv

    Yes it is possible. However, I'm not sure which version you're using. I made some changes in the last dev. I'm not sure a did a beta-release with those. Let me check tomorrow...

  • 🇫🇷France guignonv

    I've just released a beta6. I was writing automated tests to make sure it works as expected but since you were requiring joins, I released the beta and I'll continue working on the test for the next beta.

    I think I know what's going on. You're trying to map a subfield of the first storage "$.id.serial" as an id for the second. IT currently works with first-level fields. :( I'll add something to handle a JSONPath to get a field identifier value from the previous storage. Not sure when I'll have time for that but hopefully next week...

  • Assigned to guignonv
  • Status changed to Postponed 8 months ago
  • 🇫🇷France guignonv

    @nabcomi, are you still looking for a solution? I'll need to postpone the investigation and development of this feature. I'm working on the integration of xnttmulti into external entities module v3 as a native part of external entities. But I have other priorities before investigating that (hopefully in June or July).

Production build 0.71.5 2024