<?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>Date Formatter in JSON</title><link>/b/appmarket/posts/date-formatter-in-json</link><description>Overview 
 Contains a function that can be used when sending data in JSON format e.g. storing or updating data in a database using Web API to convert date formats. This listing contains the modifyjsondata() function and instructions on how to use the</description><dc:language>en-US</dc:language><generator>Telligent Community 12</generator><item><title>RE: Date Formatter in JSON</title><link>https://community.appian.com/b/appmarket/posts/date-formatter-in-json</link><pubDate>Tue, 27 Aug 2019 06:02:02 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:6251a52a-c50b-40d0-b2f9-c7b20f8c844a</guid><dc:creator>aloks0189</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;&lt;span&gt;I have uploaded the new version of this plugin along with the user guide (&amp;amp; old version plugin considering Appian older version compatibility) and hopefully it will be available to download &amp;amp; use shortly (after the approval).&lt;/span&gt;&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=723&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Date Formatter in JSON</title><link>https://community.appian.com/b/appmarket/posts/date-formatter-in-json</link><pubDate>Mon, 29 Jul 2019 17:20:08 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:6251a52a-c50b-40d0-b2f9-c7b20f8c844a</guid><dc:creator>Mike Schmitt</dc:creator><slash:comments>1</slash:comments><description>&lt;p&gt;Hi Alok - i&amp;#39;ve discovered a bug in this plug-in.&amp;nbsp; When a JSON string has its date updated and the date happens to be the last field in the CDT / Dictionary, the returned JSON string accidentally omits the final &amp;quot;]&amp;quot; and &amp;quot;}&amp;quot; characters.&amp;nbsp; It seems to only happen when the updated property is the last one in the cdt/dictionary, i.e. in my tests if I add an extra field after, the problem disappears.&lt;/p&gt;
&lt;p&gt;For example here&amp;#39;s a test dictionary with date fields for &amp;quot;created&amp;quot; and &amp;quot;modified&amp;quot;.&amp;nbsp; When i just update &amp;quot;created&amp;quot;, the output is correct as I expect:&lt;/p&gt;
&lt;p&gt;&lt;img src="/resized-image/__size/320x240/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-6251a52a-c50b-40d0-b2f9-c7b20f8c844a/pastedimage1564420717832v1.png" alt=" " /&gt;&lt;/p&gt;
&lt;p&gt;However when i update &amp;quot;modified&amp;quot;, since it&amp;#39;s the last field, it omits the last 2 closing characters:&lt;/p&gt;
&lt;p&gt;&lt;img src="/resized-image/__size/320x240/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-6251a52a-c50b-40d0-b2f9-c7b20f8c844a/pastedimage1564420757813v2.png" alt=" " /&gt;&lt;/p&gt;
&lt;p&gt;This is causing us some pretty weird and severe issues in our project where we&amp;#39;re using this plug-in, as certain things are randomly failing when the JSON text is re-loaded.&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=723&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item></channel></rss>