• Uncategorized

    V function

    The V function outputs the value of a variable. Example: Output: Hello World! Explanation: The string “Hello World!” is set as the @variable in this example. In your data extension, variables can be utilized for data attributes.

  • Uncategorized

    ProperCase function

    A financial company wants to send a promotional email to its subscribers about their new products. The company would like to display the recipient’s first name in the email and also getting the first name properly capitalized. In this specific use case, the AttributeValue function is used to retrieve the subscriber’s first name from a sendable data extension. The first name value then passed as an argument into the ProperCase function to return the first name with the first letter capitalised. The result is stored in a variable @firstName, which is then used in the email.

  • Uncategorized

    Query a Query

    Like the image above, a subquery is a query written inside another query. It is a nested query that can retrieve data from several tables. It can also be used as a special filter based on the results of other queries. The SQL execution order usually starts from the subquery, the nested query, then the parent query. In this article, we will look at the use cases of subqueries and how you can use them to make a big difference. SCENERIO 1: Company A was trying to upskill her employees and asked them to purchase a course with an offer…

  • Uncategorized

    UPSERT IN SQL

    The term Upsert in SQL allows you update a table if the specified condition already exists or insert a new row if the specified condition does not exist in the table. That is, Upsert automatically allows you write a query to detect a record in a database if it exists or not by performing the functionality of either updating the table or inserting a new record into a table which in turn allows for efficiency in database operation. The Upsert syntax varies based on the database system you use and in this article we will be exploring different methods in SQL to achieve this! Now, let’s…

  • SQL

    Two joins queries

    Select a.Customer_Id, a.Email_Address, a.First_Name, a.Delivery_Address_Postal_Code, a.Delivery_Address_Town, b.Product_Code from Master_Customer_Active a join Master_Order o on  a.Customer_Id = o.Customer_Id join Master_Order_Line_Item b on b.Order_Id = o.Order_Id

  • Uncategorized

    Create/Edit an Account via REST API

    There are numerous scenarios in which rows of data must be created into a Salesforce CRM via API. After reading this article, you will know how to create or edit a account via REST API. 1- Backend/Salesforce connection Get Access Token : Data Authentication  :  “Account” object interface definition Account fields list :  Selection values list :  Gender :  Label API Name Femele F Mal M Others O 3- Account record creation 4- Updating an Account record

  • Features Marketing Cloud - Uncategorized

    Add Data into Data Extension via REST API

    There are numerous scenarios in which rows of data must be upserted into a data extension via API. Writing to a data extension directly provides access without requiring the Website Manager skills. First you’ll need to create the API endpoint by creating an Installed Package in SFMC setup. Plus the read/write privileges to data extensions specifically for this API call. Once done, use the authorization end point to get the Bearer token which will be needed to data rows into the DE. The endpoint is: /data/v1/async/dataextensions/key:[data_extension_key/rows For example, the full URL would be similar to this where “uniqueprefixhere” is the auto-generated prefix…