[JBoss JIRA] Created: (TEIID-1306) Add support for JSON data sources (JSON translator, JSON-to-table mapping functions).
2:25 p.m.
Add support for JSON data sources (JSON translator, JSON-to-table mapping functions).
-------------------------------------------------------------------------------------
Key: TEIID-1306
URL: https://jira.jboss.org/browse/TEIID-1306
Project: Teiid
Issue Type: Feature Request
Components: Misc. Connectors
Affects Versions: 7.1
Reporter: Ken Johnson
Assignee: Steven Hawkins
Fix For: 7.2
Consider adding support in Teiid to consume services (as data sources) that return JSON
payloads rather than XML payloads. This is an increasingly common integration scenario.
The approach used for XML processing seems to be a compatible pattern for this use case.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:39 p.m.
New subject: [JBoss JIRA] Work started: (TEIID-1306) Add support for JSON data sources (JSON translator, JSON-to-table mapping functions).
[
https://jira.jboss.org/browse/TEIID-1306?page=com.atlassian.jira.plugin.s...
]
Work on TEIID-1306 started by Steven Hawkins.
Add support for JSON data sources (JSON translator, JSON-to-table
mapping functions).
-------------------------------------------------------------------------------------
Key: TEIID-1306
URL: https://jira.jboss.org/browse/TEIID-1306
Project: Teiid
Issue Type: Feature Request
Components: Misc. Connectors
Affects Versions: 7.1
Reporter: Ken Johnson
Assignee: Steven Hawkins
Fix For: 7.2
Consider adding support in Teiid to consume services (as data sources) that return JSON
payloads rather than XML payloads. This is an increasingly common integration scenario.
The approach used for XML processing seems to be a compatible pattern for this use case.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:54 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1306) Add support for JSON data sources (JSON translator, JSON-to-table mapping functions).
[
https://jira.jboss.org/browse/TEIID-1306?page=com.atlassian.jira.plugin.s...
]
Steven Hawkins commented on TEIID-1306:
---------------------------------------
It was fairly straight-forward to implement the conversion to xml using the ASL2
json-simple library. While it could be more compact to use attributes, it's easier to
do in a streaming fashion with all elements, for example:
JSON: { "firstName" : "John", "address" : {
"street" : "123 Drive" } }
XML with a root name of Person:
<Person><firstName>John</firstName><address><street>123
Drive</street></address></Person>
The pros of converting to xml is that we only need to introduce a single system function -
jsontoxml(Clob json, String rootElementName) - and we get to reuse the existing xml
processing logic (rather than choosing from one of the non-standard json path languages),
and we'll have the power of XQuery and XPath.
The cons of converting to xml is that: the conversion to XML is non-standard, json keys
need sqlxml name escaping, null values come through as empty elements, root JSON arrays
will have an additional root element, and there is an increased processing overhead.
Add support for JSON data sources (JSON translator, JSON-to-table
mapping functions).
-------------------------------------------------------------------------------------
Key: TEIID-1306
URL: https://jira.jboss.org/browse/TEIID-1306
Project: Teiid
Issue Type: Feature Request
Components: Misc. Connectors
Affects Versions: 7.1
Reporter: Ken Johnson
Assignee: Steven Hawkins
Fix For: 7.2
Consider adding support in Teiid to consume services (as data sources) that return JSON
payloads rather than XML payloads. This is an increasingly common integration scenario.
The approach used for XML processing seems to be a compatible pattern for this use case.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:51 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1306) Add support for JSON data sources (JSON translator, JSON-to-table mapping functions).
[
https://jira.jboss.org/browse/TEIID-1306?page=com.atlassian.jira.plugin.s...
]
Steven Hawkins commented on TEIID-1306:
---------------------------------------
I should mention that this is the same xml conversion strategy used by the java code
provided on JSON.org, but with better escaping and we would create a valid document for a
root array.
Add support for JSON data sources (JSON translator, JSON-to-table
mapping functions).
-------------------------------------------------------------------------------------
Key: TEIID-1306
URL: https://jira.jboss.org/browse/TEIID-1306
Project: Teiid
Issue Type: Feature Request
Components: Misc. Connectors
Affects Versions: 7.1
Reporter: Ken Johnson
Assignee: Steven Hawkins
Fix For: 7.2
Consider adding support in Teiid to consume services (as data sources) that return JSON
payloads rather than XML payloads. This is an increasingly common integration scenario.
The approach used for XML processing seems to be a compatible pattern for this use case.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:39 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1306) Add support for JSON data sources (JSON translator, JSON-to-table mapping functions).
[
https://jira.jboss.org/browse/TEIID-1306?page=com.atlassian.jira.plugin.s...
]
Steven Hawkins resolved TEIID-1306.
-----------------------------------
Resolution: Done
Added the jsonToXml function with release note and documentation updates. This also added
the json-simple library for streaming processing of the json. Still need to look at
adding streaming support to xquery/xmltable to cut down further on the size of the
document held in memory.
Add support for JSON data sources (JSON translator, JSON-to-table
mapping functions).
-------------------------------------------------------------------------------------
Key: TEIID-1306
URL: https://jira.jboss.org/browse/TEIID-1306
Project: Teiid
Issue Type: Feature Request
Components: Misc. Connectors
Affects Versions: 7.1
Reporter: Ken Johnson
Assignee: Steven Hawkins
Fix For: 7.2
Consider adding support in Teiid to consume services (as data sources) that return JSON
payloads rather than XML payloads. This is an increasingly common integration scenario.
The approach used for XML processing seems to be a compatible pattern for this use case.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:32 p.m.
New subject: [JBoss JIRA] Closed: (TEIID-1306) Add support for JSON data sources (JSON translator, JSON-to-table mapping functions).
[
https://issues.jboss.org/browse/TEIID-1306?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1306.
---------------------------------
Add support for JSON data sources (JSON translator, JSON-to-table
mapping functions).
-------------------------------------------------------------------------------------
Key: TEIID-1306
URL: https://issues.jboss.org/browse/TEIID-1306
Project: Teiid
Issue Type: Feature Request
Components: Misc. Connectors
Affects Versions: 7.1
Reporter: Ken Johnson
Assignee: Steven Hawkins
Fix For: 7.2
Consider adding support in Teiid to consume services (as data sources) that return JSON
payloads rather than XML payloads. This is an increasingly common integration scenario.
The approach used for XML processing seems to be a compatible pattern for this use case.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:13 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1306) Add support for JSON data sources (JSON translator, JSON-to-table mapping functions).
[
https://issues.jboss.org/browse/TEIID-1306?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1306:
---------------------------------------
added xsi:nil for null handling
Add support for JSON data sources (JSON translator, JSON-to-table
mapping functions).
-------------------------------------------------------------------------------------
Key: TEIID-1306
URL: https://issues.jboss.org/browse/TEIID-1306
Project: Teiid
Issue Type: Feature Request
Components: Misc. Connectors
Affects Versions: 7.1
Reporter: Ken Johnson
Assignee: Steven Hawkins
Fix For: 7.2
Consider adding support in Teiid to consume services (as data sources) that return JSON
payloads rather than XML payloads. This is an increasingly common integration scenario.
The approach used for XML processing seems to be a compatible pattern for this use case.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5060
days inactive
5180
days old
6 comments
2 participants
participants (2)
-
Ken Johnson (JIRA) -
Steven Hawkins (JIRA)