BIRT web service REST (JSON)

<p>hello, i am sorry if this topic is already open.</p>
<p>i have an web service that was create i think in JSON and uses the REST protocol, and i want to connect to <a data-ipb='nomediaparse' href='http://ws.botelhorodrigues.pt/get_portfolio_inout'>http://ws.botelhorodrigues.pt/get_portfolio_inout</a></p>
<p>If i put this link in the browser i can access it (i have to put a username and a password - that i can give to you guys to test it), when i create the data source web service data source i dont have the wsld and i put the link in the SOAP END POINT and i test the connection and i have PING succedded but i dont put the username and the password anywhere and when i create the data set i cannot see my data values.</p>
<p> </p>
<p>i already put jar files in my eclipse folder:</p>
<p>org.eclipse.birt.report.data.oda.restapi.ui_1.0.0.201211251034</p>
<p>org.eclipse.birt.report.data.oda.restapi_1.0.0.201211251034 </p>
<p> </p>
<p>and then in my eclipse data source was created a new entry Restapi Data Source, then i put the link in the HttpRequest and when i test the connection it ask me for a username and a password but i couldnÂ´t connect.</p>
<p> </p>
<p>please help me </p>
<p> </p>
<p>this is my web service structure:</p>
<p> </p>
<div>{</div>
<div> </div>
<div> â€œProduct codeâ€: integer,</div>
<div> </div>
<div> â€œProduct nameâ€: string,</div>
<div> </div>
<div> â€œSupplierâ€: string,</div>
<div> </div>
<div> â€œQuantityâ€: integer</div>
<div> </div>
<div>}</div>
<div> </div>
<div>Please notice that i did not develope the web service. If you want i can give you the username and password.</div>
<div> </div>
<div>thank you</div>

Find more posts tagged with

Comments

JFreeman

<p>Take a look at this post on the topic: <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/35221-open-json-data-from-an-url/'>http://developer.actuate.com/community/forum/index.php?/topic/35221-open-json-data-from-an-url/</a></p>
<p> </p>
<p>There are a few different methods discussed in that thread for a REST data source that sends a JSON response.</p>

hugoscp1

<p>thank you for the reply.</p>
<p>i am not an expert in this matter. its to complicated for me.</p>
<p>If you have a simple solution i would love it.</p>
<p> </p>
<p>thank you</p>

Clement Wong

<p>Please send me the user credentials to that web service <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?app=members&module=messaging&section=send&do=form&fromMemberID=24'>(via a private message</a>), and I will look into this further.</p>

Clement Wong

<p>As a follow-up to the community, a sample design was sent to hugoscp1 to demonstrate that it is possible. The attached design is a sanitized version with URL, username, password and fields changed.</p>
<p> </p>
<p>Instead of using the REST API ODA, the example uses a simple scripted data source/set. The design retrieves a JSON response from an authenticated web service.</p>
<p> </p>
<p>In the beforeOpen of the Data Set, Java 8 is assumed here to use its Base64 encoder (java.util.Base64.getEncoder()). Otherwise, if using a lower Java version, another package such as Apache Commons Codec needs to be used instead, or you could <em>*shudder*</em> encode the username:password in base64, and hard-code the value (encodedStr in the example).</p>
<p> </p>
<p>NOTE: There is an additional resource file included in the ZIP. It provides helper functions to parse JSON. <em>Place the JSON.js at the root of your Project directory. </em></p>