Profile picture for user fuliggians

Hi,

here my situation:

I would like to import data that is returned from a weservice call in json format, something like: 

{

 

  "status_product_detail": {     "codice_value": "00001",     "out_of_sla": "Within the Service Target",     "creation_ore": "10:25",     "creation_date": "21-05 10:25",     "product": "ABC",      priority": "1",     "isTopService": "false"   } }   My idea was use XML source for the datafeed. like for RSS 2.0. I could insert the web-url to obtain the data in json format. But at this point I don't know how to config the datafeed options to read the data correctly. I'm not sure, but I think that I could use the "prepocessing" that allow me to import a xsl file. But i'm not able to identify how this preprocessing file should be written to convert json format to xml.   Anyone can help me?   thanks         
by Helmut Barro
Posted on Wed, 05/22/2013 - 11:05

That's a difficult thing to do. Currently, MashZone only supports XSLT 1.0, which has only very rudimentary plain text processing capabilities.

If you're feeling adventurous, you could try to read the JSON input via the CSV operator and use MashZone's text manipulation operators to get a result - this is very error-prone (as this approach depends on the format of the JSON input regarding position of brackets, line breaks and so on), but for the example you provided I achieved some usable content:

 

Maybe in some future version there could be native JSON support, or at least XSLT 2.0 support. Till then, you have to work around.

If someone manages to write a XSLT 1.0 script that does that work - I'm really looking forward to your solutions!

0

Featured achievement

Genius
You like to help others solve their problems by answering questions.
Recent Unlocks
  • KF
  • KH
  • RG
  • Profile picture for user Vee_ARIS
  • Profile picture for user smarty
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock