Populate Confiforms form data from webservice request

[Mar Demolag]

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.

[Mar Demolag · Accepted solution]

I think I found a trick solution:

1. Add to F a field temp of type multi-select
2. Set p to Text Field
3. IFTTT1: CreateEntry on F:
   • Params: entryId=[entry.id]&temp=[entry.f.items.key.asList]
4. IFTTT2: Copy Entries from F to P:
   
   • Params: p=[entry.temp]
   • Flatten: True
   • Flatten By Field: temp

It works, but I'll be happy for a more clean solution.

[Alex Medved _ConfiForms_]

If you want to copy a flattened values from a multi-value field then this will be the correct approach

[Mar Demolag]

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

[Alex Medved _ConfiForms_]

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