Thanks for your reply Julius,

But the getPet() is accessing the DB query using SpringBoot. The findAll() method return only  List type not String type.

So, do you have any other ideas.  If yes, Please let me know.

Okay, Thanks Alex.

If any other possible to view that table records , please let me know.

Thanks,

Vikram

Oops!!!, 

I connected the Cache from Power BI using ODBC connection. And I can able to view the tables but I could't able to view the data records. getting some error when I shoot on the table name. I could't trace what I'm missing. Please help me

Error Message: "Value cannot be null. Parameter name: exceptionType"

Thanks,

Vikram

WOW!!!

Its working..

Thanks Alex, thanks for your help.

Hi Benjamin,

No, I am not running an Intersystems IRIS server

I am new to Intersystems IRIS platform, So I need to know  Where I can run the IRIS code and Where is the IRIS DB. And how can I find those things.(like cache studio, management portal,and so on...)

Your guidance would be helpful for me.

Best 

Vikram 

Hi Stefan,

I agree with you but I have to give my best to my team. So please help me....

Sure Robert,

I will definitely read those docs.

Thanks for your response.

Vikram.

Thanks for all,

Now I am clear. This is very useful for me.

Thanks

Vikram Annadurai.

Thanks Sourabh,

Its a wonderful idea. This make me a different way of thinking.

Thanks a lot....

Thanks Robert,

I missed this doc. Now I got some idea.

Thanks you so much....

Thanks for your support Eduard..

But what to do, I have a licence problem

Thank you Neerav 

I will do it, after i resolve my licence issue...

Hi David,

Thanks for ur Comment.

           I have a license problem, That's why I am getting that error.

Hi Eduard,

CROSRestAPI.cls:

Class User.CROSRestAPI Extends %CSP.REST
{
Parameter CHARSET = "utf-8";
Parameter CONTENTTYPE = "application/json";
XData UrlMap [ XMLNamespace = "http://www.intersystems.com/Urlmap" ]
{
<Routes>
<Map Prefix="user/coffee" Forward="User.CROSRestAPI"/>
<Route Url="/CoffeeMaker" Method="POST" Call="CreateCoffee"/>
<Route Url="/CoffeeMaker:id" Method="PUT" Call="UpdateCoffee"/>
</Routes>
}
ClassMethod CreateCoffee() As %Status
{
s CoffeeProp = ##class(User.PropertyName).%New()
s CoffeeProp.CoffeeName=%request.Data(CoffeeName)
s CoffeeProp.CoffeeColor=%request.Data(CoffeeColor)
s CoffeeProp.CoffeePrice=%request.Data(CoffeePrice)
s Status = CoffeeProp.%Save()
}
}

And I have a complete version of Cache.

Hi Francis,

 Yeah I added that. Then also I getting that same error.