Unable to create a schema from JSON object usingBW Json Utils
Article ID: KB0094002
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 .
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",
Issue/Introduction
Unable to create a schema from JSON object usingBW Json Utils
Feedback
Yes
No
Powered by
