Gigya Job Openings

Silverpop Dataflow - Inbound

Skip to end of metadata
Go to start of metadata

The dataflow that loads data from Silverpop into Gigya involves renaming Silverpop fields to match Gigya's format, and using a JEXL expression in the field.evaluate step to transform the Silverpop "T/F" values to Gigya's "true/false". In this example, the subscription status is written to the data.subscribed field. If you are using Enterprise Preference Manager's communication preferences, you can write the status to any subscription field (e.g. subscriptions.mySub.email.isSubscribed). The various dataflow steps are described in greater detail here: Component Repository

 

 

{
 "name": "Silverpop_Dataflow_Inbound",
 "description": "silverpop > rename > evaluate > account",
 "steps": [
  {
   "id": "silverpop",
   "type": "datasource.read.silverpop",
   "params": {
    "clientId": "...",
    "clientSecret": "...",
    "refreshToken": "...",
    "podNumber": 1,
    "host": "...",
    "username": "...",
    "password": "...",
    "listId": "...",
    "columns": "Opted Out,GigyaUid,Email"
   },
   "next": [
    "rename"
   ]
  },
  {
   "id": "rename",
   "type": "field.rename",
   "params": {
    "fields": [
     {
      "sourceField": "GigyaUid",
      "targetField": "UID"
     },
     {
      "sourceField": "Email",
      "targetField": "profile.email"
     },
     {
      "sourceField": "Opted Out",
      "targetField": "data.subscribed"
     }
    ]
   },
   "next": [
    "evaluate"
   ]
  },
  {
   "id": "evaluate",
   "type": "field.evaluate",
   "params": {
    "language": "jexl",
    "fields": [
     {
      "field": "data.subscribed",
      "expression": "data.subscribed eq 'T' ? true : false"
     }
    ]
   },
   "next": [
    "account"
   ]
  },
  {
   "id": "account",
   "type": "datasource.write.gigya.account"
  }
 ]
}
  • No labels