<p>Hello.</p>
<p>I need help with the report I'm working on.</p>
<p> </p>
<p>What I need is to obtain json object via URL, parse and create a report out of it. I've been using Oracle SQL and PostgreSQL before and I'm not a coder so this is beating me..</p>
<p> </p>
<p>I'v searched for solution for quite a while now but haven't been able to solve the problems with getting info out of the json object.</p>
<p> </p>
<p>There's a simple solution which I've used to practise with (example from kclark):</p>
<p>(<a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/?app=blog&module=display%25C2%25A7ion=blog&blogid=45&showentry=471'>http://developer.actuate.com/community/forum/?app=blog&module=display%25C2%25A7ion=blog&blogid=45&showentry=471</a>)</p>
<p> </p>
<p>Things done at the moment (following the example above):</p>
<p>1) I have created a scripted data source "Data source"</p>
<p>2) Then I created a scripted data set "Json_DS"</p>
<p>* The scripted "Data source" was selected as data source for the data set</p>
<p>* The output columns (name, title, phone) were created accordingly</p>
<p>* The Open and Fetch -scripts were added to Json_DS data set.</p>
<p>3) Json file was added to C:/tmp and the file location was updated into open-script:</p>
<p>.."C:/tmp/employee.json")..</p>
<p> </p>
<p>But: even this simple example of reading and managing the json object produces an error:</p>
<p><strong><a data-ipb='nomediaparse' href='
https://www.google.fi/search?client=firefox-b-ab&biw=1903&bih=1232&q=birt+report+"FAILED+TO+CREATE+INSTANCE"&spell=1&sa=X&ved=0ahUKEwjege-r0JTSAhXIWCwKHRxnDeYQBQgVKAA'>"<b><i>FAILED TO CREATE INSTANCE</i></b>"</a></strong></p>
<p> </p>
<p>I checked this there shouldn't be a privilege problem with reading the file.</p>
<p>Could this be a problem with importPackages?</p>
<p> </p>
<p>WHAT IS NEEDED?</p>
<p>I need to read a 2-dimentional json object via URL and create a report out of it.</p>
<p>IF possible, I'd need to read 3 json objects and mix them together in 1 excel file (3 tabs).</p>
<p> </p>
<p>THE QUESTIONS:</p>
<p>1) Could I use the following example, (Answer #2)?</p>
<p><a data-ipb='nomediaparse' href='
http://stackoverflow.com/questions/31703282/how-to-parse-a-two-dimensional-json-object-in-java'>http://stackoverflow.com/questions/31703282/how-to-parse-a-two-dimensional-json-object-in-java</a></p>
<p>-> OR is there an easier solution available?</p>
<p>2) If the code above is used, should it be placed in data sets Open or Fetch script?</p>
<p>3) Could someone please show me an example how to construct this report (if not out of these parts, what sould be done)?</p>
<p> </p>
<p>I attach a pic of the partial json object I'll use to create the report.</p>
<p> </p>
<p>Please help, I'm running out of time and still have to figure out why I can't even make the simple example work..</p>
