Populate Confiforms form data from webservice request

Question

Here's my specific scenario:

* I have Form F with field f: webservice dropdown field
* I have Form P with field p
* f's webservice request returns JSON data like:

{ 
   'key': 'f1', 
   'label':'fl1', 
   'items':[
      {'key':'p1', 'label':'pl1'},
      {...},
      ...
   ]
}

Is there a way to automatically populate Form P using the items array from field f when registering rows on Form F?

I considered IFTTT, but its "create entry" action only allows creating one row per rule execution, which isn't ideal for my use case.

Any suggestions would be greatly appreciated. Thanks!

Edit: While p ideal field type would be webservice dropdown, if it's not possible, even type text that contain only the key from each item would be helpful.

Demolag · Answer

Followup question:
On the solution above, only the key is passed to the 2nd form.
Now I've realized that I need the other fields as well.
Is there a way to do populate it to contains all of the fields?

I've tried to do the same way but with the whole inner json for each of the items, but the multi-select field see the comma between the json parameters as part of the lists, so instead of getting:

* {'key':'p1', 'label':'pl1'}
* {'key':'p2', 'label':'pl2'}

I get:

* {'key':''p1
* 'label':'pl1'}
* {'key':'p2'
* 'label':'pl2'}

and the 2nd form get new 4 entries instead of 2.

Tried also to reference the original 1st form entry with a smart-field, and to get the info using: [entry.fRef.f.items.(key=[entry.p])], but it seems that the JSON field value match does not support referencing entry values.

Alex Medved _ConfiForms_ · Answer

You cannot flatten by the field in another form, so it needs to be copied locally from the [entry.f.items.asList]

Demolag · Answer

Is there no way to skip the first part and flatten it directly based on f.items?