Unable to create a schema from JSON object usingBW Json Utils

Unable to create a schema from JSON object usingBW Json Utils

book

Article ID: KB0094002

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Description:
When attempting to create a schema file from a JSON object using the "BW Json Utils >  Create Schema from JSON payload", no error or popup is seen and the schema is not created.
Symptoms:
No error, popup or schema created.
Cause:

JSON nulls are not supported in BW 6.2.x. This is documented at https://docs.tibco.com/pub/activematrix_businessworks/6.2.2/doc/html/GUID-8758335B-281D-4691-98AD-56BF1BF0FAD2.html .

Issue/Introduction

Unable to create a schema from JSON object usingBW Json Utils

Resolution

A sample JSON object is shown below.
++++

{
"Lead" : [{
"LeadId" : 454,
"PropertyId" : 7,
"LeadType" : "phone-in",
"DateLog" : "2014-07-1713:18:00",
"LastUpdate" : "2014-07-1713:18:00",
"DisplayStatus" : "Dead",
"HomePhone" : "675-324-3444",
"CellPhone" : "675-324-3444",
"WorkPhone" : "675-324-3444",
"PropertyPhone" : "234-234-2342",
"LeadDescription" : "Transferred by: QA Tester of Big Sky ApartmentsrnrnActions taken by previous properties:rnPhoned by Lead2Lease of Big Sky Apartments",
"MoveInDate" : null,
"LeadSource" : "daily news",
"SecondaryLeadSource" : "Apartments.net",
"EmailAddress" : "",
"PropertyZipCode" : "50566",
"ProspectZipCode" : "77493",
"DesiredBedCount" : 2.00,
"DesiredRent" : 1238.0000
}],
"Action" : [{
"ActionID" : 1533, 
"Action" : "Phoned",
"DateLog" : "2014-12-19T05:42:00"
}], 
"Quote" : [{
"QuoteId" : 751, 
"AskingRent" : 1109.0000,
"DateCreated" : "2015-03-16T14:02:17.72"
}],
"Phone" : [{
"PhoneID" : 631, 
"PhoneDateLog" : "2014-07-17T13:18:29.79",
"PhoneCallDuration" : "1900-01-01T00:00:06"
}],
"Email" : [{
"EmailID" : 100, 
"Email" : "",
"DateGenerated" : "2014-07-17T13:18:35.677"
}]
}

++++

Change the MoveInDate to a non null value in the JSON payload as shown below.


Example:


Change


"MoveInDate" : null,


To


"MoveInDate" : "2014-07-1713:18:00",