Need help with External Lookup field, we have a custom field called DE:B Number at project level custom forms. Now I am trying to get a external look up field at issue level custom form for users to map existing DE:B Number which is available at project level Any help would be highly appreciated thanks in advance.
I am trying to use API URL as $$HOST/attask/api/v18.0/project/search?status={DE:B Number}&$$QUERY
JSON Path: $.data[*].name
So DE:B Number is a field - I don't understand why you would equate it with the project status?
You probably want something like
$$HOST/attask/api/v18.0/project/search?DE:B Number_Mod=notblank&DE:B Number_Mod=$$QUERY&fields=DE:B Number
and
JSON Path: $.data[*].['DE:B Number']
This will list all B Number values across all projects, as long as the field has a value. However, you WILL get duplicates. If you want a unique list, use Fusion instead of call to API
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.