Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Custom Form Beta - External Lookup via API

Avatar

Level 2

Hi,

Interested in setting up a simple Proof of Concept to demonstrate the functionality of the External Lookup field.

  1. Has anybody tried this yet?
  2. Does Adobe have any sandbox resources to build a small client facing demo or are there any recommended/recognized APIs that would be suited to this task? 

Cheers!

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi,

 

yes, it's not as complicated as it seems at first glance.

 

You will be only able to setup an external lookup field using the new (beta) form designer.

You can try using a dummy API like this:

https://dummyjson.com/products 


If you have a look at the output in your browser, you will see, that it has the following format:

 

{
"products": [
{
"id": 1,
"title": "iPhone 9",
"description": "xyz",
...
]
}

 

So, to get the titles into the new field, you have to use the following JSON path:

 

$.products[*].title

 

 

lgaertner_0-1706517033740.png

 

 

Regards

Lars

View solution in original post

3 Replies

Avatar

Correct answer by
Level 10

Hi,

 

yes, it's not as complicated as it seems at first glance.

 

You will be only able to setup an external lookup field using the new (beta) form designer.

You can try using a dummy API like this:

https://dummyjson.com/products 


If you have a look at the output in your browser, you will see, that it has the following format:

 

{
"products": [
{
"id": 1,
"title": "iPhone 9",
"description": "xyz",
...
]
}

 

So, to get the titles into the new field, you have to use the following JSON path:

 

$.products[*].title

 

 

lgaertner_0-1706517033740.png

 

 

Regards

Lars

Avatar

Level 1

I have a scratch custom form and testing project with that custom form on it.  That is where I test and create proof of concept and tweak them as needed for custom forms in production.

 

One POC I am running some tests for is a sub category set of choices that are dependent on the primary category choices. I have gotten a one to one work and am now working on a multiple to multiple.