AnsweredAssumed Answered

Quoted JSON translated to NULL in Message shape

Question asked by cbeaudette606890 on Jun 7, 2016
Latest reply on Jun 7, 2016 by cbeaudette606890

I've got JSON returned from a Map shape and I'm attempting to place it inline into a Message shape, but it's translated as NULL after it passes through the Message shape.  I've surrounded the {1} placeholder in single quotes per this post, but still getting [null] returned.

 

My Message shape uses Root as the Element value of my JSON Profile.

 

Message shape config:

 

Parameter value:

 

JSON Profile (truncated at bottom, but the necessary info is there -- I've verified that the fields passed to the Message shape match the fields in the Profile in number and name):

 

This is the JSON passed into my Message shape:

{

  "ResponseCode" : "1",

  "Customer" : "123456       ",

  "CurrentBalance" : "1044.02",

  "AccountStatus" : "AC",

  "IVRStatus" : "5",

  "BillDate" : "20151222 000000.000",

  "BillDueDate" : "20160121 000000.000",

  "BillAmount" : "1044.02",

  "PastDueAmount" : "1044.02",

  "FirstName" : "                    ",

  "LastName" : "JOE BLOW APARTMENTS OWNERS ASSOCIATION                     ",

  "StreetNumber" : "1234      ",

  "StreetName" : "MAIN ST  ",

  "CityTown" : "ANYTOWN                 ",

  "StateProv" : "WA",

  "ZIPPostal" : "99999     ",

  "PaymentAmount" : "-1044.02",

  "PaymentDate" : "20151110 000000.000",

  "ColStatusCode" : "OK",

  "CashOnly" : "false",

  "DisconnectDate" : "20160309 000000.000",

  "PendingPayment" : "0.00",

  "PaymentPlanType" : "0",

  "DrawPayment" : "false",

  "ArrangementAmount" : "0.00",

  "ArrangementDate" : "19000101 000000.000",

  "ArrangementStatus" : "0",

  "PhoneNumber" : "                    ",

  "PhoneType" : "HO",

  "PhoneDesc" : "               ",

  "AccountType" : "RE",

  "CommentCode" : "Some comments,"

}

 

This is what's returned from the Message shape:

{

   "interfaceResponse":{

      "interface": "CIS",

     "data": [null]

   },

   "responseID":"",

   "errors":[]

}

 

What's the trick that I'm missing??

Outcomes