Retrieving a contact guid based on email address

@benjamen02
you can use the key attribute syntax only if you have the alternate key defined.

If you do not have the alternate key then your choice is to use FetchXml to retrieve the records (or use Query by attribute). Note that with fetch you will potentially have multiple rows coming back so search by email could return 0, 1, or many matching records.

HTH

• This reply was modified 3 years, 9 months ago by alexacrm.

ok thanks

Using the Dataverse plug in do you still reference the libraries like this:

use AlexaCRM\Nextgen\ConnectionService;
use AlexaCRM\Xrm\{
EntityReference,
Entity,
KeyAttributeCollection,
ColumnSet
};`

$query = new \AlexaCRM\Xrm\Query\QueryByAttribute( ‘contact’ );
$query->AddAttributeValue( ‘lastname’, ‘Example’ );
$query->AddOrder( ‘firstname’, \AlexaCRM\Xrm\Query\OrderType::Descending() );
$query->ColumnSet = new \AlexaCRM\Xrm\ColumnSet( [ ‘fullname’, ’emailaddress1′ ] );
$collection = $client->RetrieveMultiple( $query );

or do not need to put the whole “\AlexaCRM\Xrm\Query\QueryByAttribute” path in

@benjamen02

use AlexaCRM\Xrm\{
EntityReference,
Entity,
KeyAttributeCollection,
ColumnSet
};

is just a shortcut for

use AlexaCRM\Xrm\EntityReference;
use AlexaCRM\Xrm\Entity;
use AlexaCRM\Xrm\KeyAttributeCollection;
use AlexaCRM\Xrm\ColumnSet;

Whether to punch in an explicit full reference or use statement – it’s really up to you and your preferred style of coding.

HTH
George

Got it thanks George