cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Re: Parse JSON Custom Action

Jump to solution

Ok, thanks Caroline! Appreciate it.

0 Kudos
Reply
cju
Nintex Newbie

Re: Parse JSON Custom Action

Jump to solution

you're welcome

0 Kudos
Reply
dan_stoll
Nintex Newbie

Re: Parse JSON Custom Action

Jump to solution

Someone with better skills than I may be able to build a custom action utilizing

http://www.newtonsoft.com/json/help/html/ConvertJsonToXml.htm to convert JSON Output to XML. this would make it easy then to parse, rather than using Regex

Reply
Not applicable

Re: Parse JSON Custom Action

Jump to solution

I am still a bit surprised that Nintex does NOT provide a parser for json given how widely used JSON is. Is there a reason why this is not provided by Nintex out-of-the-box?

Reply
cju
Nintex Newbie

Re: Parse JSON Custom Action

Jump to solution

There was maybe not so many demands for that (and many demands for other improvements).

You can add your vote on Nintex user voice for this feature which is under review :

Improve Web Request action to support new input methods such as JSON – Customer Feedback for Nintex

Reply
Highlighted
john_luangci
Nintex Newbie

Re: Parse JSON Custom Action

Jump to solution

We've recently had to work on an integration project for user provisioning to multiple SaaS systems, and unfortunately I can confirm that reg ex is the only way to achieve this via ootb action. I found this method would work okay for json responses that are flat and simple and nature. Check out Vadim's post in the link below as it has a UDA that I have found useful Uber Price Estimate UDA

But for more complex responses e.g. arrays your best bet could be to create a custom action and deploy it to your custom environment.

Alternatively if you do not have the resources, capacity or willingness to go down the custom route I have worked on a test case recently of leveraging the new Logic Apps and API Apps capability from Microsoft's BizTalk Team. (Using the BizTalk JSON Encoder connector in Logic Apps | Microsoft Azure App Service ). Essentially this approach would have us use the JSON to XML converter API app which we can then expose as a web service via the GUI. Having been given an XML output we can then use Nintex's Query XML action to get the data we want.

I have a blog post on using this technology in nintex workflow on.premise going into more detail, please  private message me if you would like a link. Otherwise I've found the logic app and API app quite easy to use.

Before you do use this technology in a production environment, do note that it is still currently in public preview and has not hit General Availability yet. In addition it is worth evaluating whether the free plan would meet your needs and if not whether the cost of the paid plans would be sufficient for your needs.

Reply
eric_halsey
Nintex Newbie

Re: Parse JSON Custom Action

Jump to solution

Hi John,

Thanks for the detailed response and that sounds like a great approach.  We may do something similar but use the Oracle API Gateway instead of BizTalk since we already have it.  At some point though, we'll probably create a custom action as going through another layer seems like wasted cycles.  I'll be sure to post something once we do.

Regards,

Eric

Reply