<?xml-stylesheet type="text/xsl" href="https://community.appian.com/cfs-file/__key/system/syndication/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>JSON Tools</title><link>/b/appmarket/posts/load-json-file-to-database</link><description>Overview 
 Given a huge JSON to process and store in the database, this plug-in avoids using a long string in the process model and improves performances and memory usage. The big JSON can then be stored in a document and the document passed to the plug</description><dc:language>en-US</dc:language><generator>Telligent Community 12</generator><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Tue, 16 Sep 2025 22:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v1.12.0 Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;&lt;span&gt;Added new function getdeepestvalidjsonpath&lt;/span&gt;&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Tue, 01 Jul 2025 22:00:01 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v1.11.1 Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Added new functions: fixjson (attempts to fix json errors often seen when generating via prompts)&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Mon, 16 Jun 2025 09:58:52 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>vigneshkumarr</dc:creator><slash:comments>1</slash:comments><description>&lt;p&gt;Hi All,&lt;br /&gt;&lt;br /&gt;is there any sample format for jsonSchema field or any reference documentations for this tool? &lt;br /&gt;&lt;br /&gt;function name:&lt;/p&gt;
&lt;p&gt;validatejsonbyschema(&lt;/p&gt;
&lt;p&gt;jsonSchema:,&lt;br /&gt; jsonData:&amp;nbsp;&lt;br /&gt; )&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Tue, 03 Jun 2025 12:53:27 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>davidl0016</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Hello, we&amp;#39;ve found inside a cve vulnerability (CVE-2025-48734) with the&amp;nbsp;&lt;b&gt;commons-beanutils v1.9.4 dependendency of this plugin. Could you please fix it ?&lt;/b&gt;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Thanks in advance&amp;nbsp;&lt;/b&gt;&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Fri, 09 May 2025 10:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v&lt;/strong&gt;&lt;strong&gt;1.10.0 Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Added new functions: fixjson (attempts to fix json errors often seen when generating via prompts)&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Wed, 26 Mar 2025 22:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v1.9.0 Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Added new functions: appendJsonListByPath, deleteJsonElementByPath, jsonPathIfExists, updateJsonByPath&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Fri, 14 Mar 2025 10:00:01 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v1.8.2 Release Note&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Json-smart library upgraded for security patch.&amp;nbsp;&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Fri, 31 Jan 2025 23:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v1.8.1 Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Fixing min version in plug-in&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Fri, 27 Dec 2024 23:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v1.8.0 Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Adding pretty print json formatting function&lt;/li&gt;&lt;li&gt;Adding functionality to evaluate json expressions and merge json data with text template.&amp;nbsp;&amp;nbsp;&lt;/li&gt;&lt;li&gt;Functionality is based on this library: &lt;a rel="nofollow" target="_blank" href="https://github.com/IBM/JSONata4Java"&gt;github.com/.../JSONata4Java&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Thu, 19 Dec 2024 23:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v&lt;/strong&gt;&lt;strong&gt;1.7.0 Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Adding functionality to evaluate json expressions and merge json data with text template.&amp;nbsp;&amp;nbsp;&lt;/li&gt;&lt;li class="ql-indent-1"&gt;Functionality is based on this library: &lt;a rel="nofollow" target="_blank" href="https://github.com/IBM/JSONata4Java"&gt;github.com/.../JSONata4Java&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Wed, 04 Dec 2024 23:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v&lt;/strong&gt;&lt;strong&gt;1.6.0 Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;&lt;span&gt;Replace references to private Appian APIs&lt;/span&gt;&lt;/li&gt;&lt;li&gt;[private] com.appiancorp.common.ArrayUtil.asList(java.lang.Object[])&lt;/li&gt;&lt;li&gt;[private] com.appiancorp.common.ArrayUtil.isEmpty(java.lang.Object)&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Fri, 28 Jun 2024 06:00:13 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>Anna P</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Hi Team,&lt;/p&gt;
&lt;p&gt;&lt;span&gt;could you please help us&amp;nbsp;in&amp;nbsp;&lt;span class="ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak" dir="ltr"&gt;Load JSON to&amp;nbsp; database&amp;nbsp;&lt;/span&gt;configuration, there is no documentation so we tried to understand by looking into code but we observed&amp;nbsp;&lt;/span&gt;&lt;span&gt;&lt;span class="ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak" dir="ltr"&gt;parameters are different in SS configuration and the code.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Tue, 07 May 2024 22:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v1.5.0 &lt;/strong&gt;&lt;strong&gt;Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Upgraded ValidateJSONBySchema to validate JSON messages that have arrays at the top level, including nested arrays.&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Thu, 11 Apr 2024 09:52:18 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>pierpaolo.longobardi</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Hi, is there a way to download the older versions of this plug in?&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: JSON Tools</title><link>https://community.appian.com/b/appmarket/posts/load-json-file-to-database</link><pubDate>Wed, 07 Feb 2024 23:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:cdf5f11d-3690-4456-bd90-8fa1ac7cbddc</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v1.4.1 Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Upgraded json-path library for security fix&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=3171&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item></channel></rss>