AnsweredAssumed Answered

Json parsing

Question asked by michaelkirwan on Jan 14, 2018
Latest reply on Jan 16, 2018 by fmpdude

Hi All

I am completely baffled when it comes to the new Json functions. I'm going insane trying different permutations. I can resolve it using the old text parsing functions but I am assured the new Json functions is far easier!!

Can someone please guide me as to how I can use Json to parse these three sample Wofoo Form entries into 3 separate records, collecting the information from each of the fields.

 

When I query Wofoo for my entries, I get a response that comes like this:

 

{"Entries":[{"EntryId":"26","Field1":"6598","Field7":"Express + Signature","Field4":"568974545","Field5":"89215487","DateCreated":"2018-01-14 06:52:08","CreatedBy":"production@media.com","DateUpdated":"","UpdatedBy":null},{"EntryId":"27","Field1":"9862","Field7":"Parcel","Field4":"986542123","Field5":"874861195","DateCreated":"2018-01-14 06:53:06","CreatedBy":"production@media.com","DateUpdated":"","UpdatedBy":null},{"EntryId":"28","Field1":"6354","Field7":"DHL","Field4":"762354875","Field5":"443652356232","DateCreated":"2018-01-14 06:54:21","CreatedBy":"production@media.com","DateUpdated":"","UpdatedBy":null}]}

 

When I clean it up using the JSONFormatElements function, I get this:

{

"Entries" :

[

  {

   "CreatedBy" : "production@media.com",

   "DateCreated" : "2018-01-14 06:52:08",

   "DateUpdated" : "",

   "EntryId" : "26",

   "Field1" : "6598",

   "Field4" : "568974545",

   "Field5" : "89215487",

   "Field7" : "Express + Signature",

   "UpdatedBy" : null

  },

  {

   "CreatedBy" : "production@media.com",

   "DateCreated" : "2018-01-14 06:53:06",

   "DateUpdated" : "",

   "EntryId" : "27",

   "Field1" : "9862",

   "Field4" : "986542123",

   "Field5" : "874861195",

   "Field7" : "Parcel",

   "UpdatedBy" : null

  },

  {

   "CreatedBy" : "production@media.com",

   "DateCreated" : "2018-01-14 06:54:21",

   "DateUpdated" : "",

   "EntryId" : "28",

   "Field1" : "6354",

   "Field4" : "762354875",

   "Field5" : "443652356232",

   "Field7" : "DHL",

   "UpdatedBy" : null

  }

]

}

 

Thanks in advance..... Michael

Outcomes