A developer wants to retrieve all recordsin the OrderDetails data extension which are associated with a particular customer.
Which two AMPscript functions would return a suitable rowset?
Choose 2 answers
To retrieve multiple records associated with a particular customer from the OrderDetails data extension, the LookupRows and LookupOrderedRows functions are suitable. These functions return a rowset containing the records that match the specified criteria.
LookupRows: Retrieves a rowset of records based on specified criteria.
Example:
ampscript
Copy code
SET @rows = LookupRows('OrderDetails', 'CustomerID', @customerID)
LookupOrderedRows: Retrieves a rowset of records based on specified criteria and allows for sorting.
Example:
SET @rows = LookupOrderedRows('OrderDetails', 0, 'OrderDate DESC', 'CustomerID', @customerID)
: Salesforce AMPscript LookupRows
Northtrn Trail Outfitters mistakenly synced the User_Salesforce object which added to their billable contact count.
What should be recommended to remove these contacts'
To remove contacts mistakenly synced from the User_Salesforce object, the recommended approach is to put the synced records into a sendable data extension and use Contact Delete (C). This method allows for the systematic deletion of these contacts from the All Contacts table without affecting other data.
Salesforce Marketing Cloud Contact Delete
Managing Contacts in Marketing Cloud
A developer needs to use the 'contacts/ route of the REST API to update records in a data extension.
What should the developer verify before making the API call?
Before using the 'contacts/' route of the REST API to update records in a data extension, the developer should verify that the data extension should be linked in an AttributeGroup in Contact Builder (D). This ensures that the data extension is part of the contact model and can be accessed and updated using the REST API.
Salesforce Marketing Cloud REST API
Contact Builder and Attribute Groups
=========================
Questions no: 153Verified Answer: DComprehensive Detailed Step by Step Explanation with
Salesforce Marketing Cloud AMPscript Guide
Salesforce Marketing Cloud Dynamic Content Best Practices
=========================
Questions no: 154Verified Answer: DComprehensive Detailed Step by Step Explanation with
Salesforce Marketing Cloud API Authentication
Token Management Best Practices
Top of Form
A developer wants to create a Synchronized Data Extension containing Lead data from Sales Cloud. They only want to include record which contain a phone number. Each of the following flied contains this information per these rules: -Phone is not black (Data Type = Phone) -PhoneExist is true (Data Type = Boolean) -ValidPhone is 'true' (Data Type = Formula(Boolean)) -ContactType equals 'Phone' (Data Type = Text). Which field could be used to select a subset of records in the synchronization configuration?
To select a subset of records that contain a phone number, the field that ensures the phone number is valid and non-blank should be used.
ValidPhone Field: The ValidPhone field is a formula field that evaluates to 'true' if the phone number is valid. This ensures that only records with a valid phone number are included in the synchronization.
: Salesforce Data Synchronization
A company has chosen to use the REST API for triggered sends, but they continue to get the following error during their testing: "Unable to queue Triggered Send request. There are no valid subscribers." They were informed that the SOAP API provides more information about the error, and found that their payload did not include a required data extension field.
Which element of the SOAP API response provides this level of detail?
In the SOAP API response, the element that provides detailed information about the error, including missing required data extension fields, is ErrorDescription (A). This element contains a description of the error, helping developers understand and resolve the issue.
Salesforce Marketing Cloud SOAP API
SOAP API Error Handling
Kevin Scott
4 days agoRobert Turner
21 days agoLinda Morris
1 month agoAmanda Parker
2 months agoMichelle Howard
1 month agoLisa Rodriguez
1 month agoEric Howard
30 days agoKimberly Wright
24 days agoDavid Clark
22 days agoMartha
2 months agoPedro
2 months agoWade
3 months agoOlga
3 months agoKimbery
3 months agoKrissy
3 months agoAmber
4 months agoSherell
4 months agoHaydee
4 months agoTomas
4 months agoStephaine
5 months agoCherilyn
5 months agoLavonna
5 months agoKip
5 months agoKaitlyn
6 months agoSuzi
6 months agoFernanda
6 months agoEun
6 months ago