javielico

<script runat="server">
    Platform.Load('core', '1')

    /* -------------------------------------------------------------------------

        1. Global Variables
            1.1. Contact Deletion DE Key
            1.2. REST API Authorization
            1.3. Error Handling
        2. Helper Functions

javielico

### Keybase proof

I hereby claim:

  * I am javielico on github.
  * I am javisanchez (https://keybase.io/javisanchez) on keybase.
  * I have a public key ASClIYsVLr4XfTTzp5xxyaOZ1u5trdO1t8MjmCnD9aNfyQo

To claim this, I am signing this object:

javielico

use PKPass\PKPass;

require('../vendor/autoload.php');

// Replace the parameters below with the path to your .p12 certificate and the certificate password!
$pass = new PKPass('../Certificates.p12', 'password');

// Pass content
$data = [
    'description' => 'Demo pass',

javielico

SELECT
      sl.SubscriberKey          AS SubscriberKey
    , sl.SubID                  AS SubscriberID
    , sl.EmailAddr              AS EmailAddress
    , sl.EmailName_              AS EmailName
    , j.JourneyName             AS JourneyName
    , j.VersionNumber           AS JourneyVersion
    , s.EventDate               AS SentDate
    , CASE
        WHEN job.DeliveredTime IS NOT NULL THEN CONVERT(NVARCHAR, job.DeliveredTime)