Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!
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 9

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

2 Replies

Avatar

Correct answer by
Level 9

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