cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KimB
Level: Powered On

Web API: How to retrieve a record based on an alternate key with lookup field?

Hi

 

Using Web API, we are used to retrieve a record quite often with an alternate key:

{{webapiurl}}/cr23b_tmps(cr23b_string1='abc')

 

However, in this case, the alternate key is based on a lookup (e.g. accountid). Adding a lookup field in an alternate key should be possible, according to this documentation: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/define-alternate-keys-entit...

 

In Web API, I don't seem to find a right way to use the alternate key (based on lookup) in a GET request. These are some tests which did not work:

  • GET {{webapiurl}}/cr23b_tmps(cr23b_accountid=’1275227F-93A8-E911-A821-000D3ABA5555')
  • GET {{webapiurl}}/cr23b_tmps(cr23b_accountid='/accounts(1275227F-93A8-E911-A821-000D3ABA5555)')

 

Does anyone know how to do this?

 

Kind regards.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Users Online
Currently online: 177 members 4,946 guests
Please welcome our newest community members: