CompositionAPI independent Datatypes

Question

If I use HandleByQuery or HandleBySqlStatement I get have a resulting json which reflects the DB structure. 
 
 Now I need to provide a REST API for querying some date in the IdentityManager and I want to use my own DateStructure for the resulting json. 
 As simple example I've done this: 
 builder.AddMethod(Method.Define("eset")
.HandleGet(async qr =>{
 Query q = Query.From("ESet").Select("Ident_ESet").Where("UID_ESetType = N'e65d9baa-d737-4de9-a005-2f1f8f6263c8'");
 var entityRead = await qr.Session.Source().GetCollectionAsync(q);
 ESetList esets = new ESetList();

foreach (var eset in entityRead){
 esets.esets.Add(new ESet() { Ident_ESet = eset.GetValue("Ident_ESet") });
 }
 return esets;
}));} 
 
 Now the Result looks like: 
 
 {
"Result": {
"esets": [
{
"Ident_ESet": "xxxx"
},
{
"Ident_ESet": "yyyy"
},
{
"Ident_ESet": "zzzz"

...

How can I get rid of the "Result:" entry? 
 I just need: 
 
 {

"esets": [

{
"Ident_ESet": "xxxx"
},
{
"Ident_ESet": "yyyy"
},
{
"Ident_ESet": "zzzz" 
 
 ... 
 
 Or is there an easier way to do the request from scratch?

prueegg · Accepted Answer

It works now as expected. The additional bracket with the "Result": {...} disappears while using the CancellationToken as well: 
 .HandleGet(async (qr, ct) =>
 {

 Query qEsets = Query.From("ESet").Select("Ident_ESet", "Remarks", "UID_PersonResponsible", "UID_ESetType").Where("UID_ESetType = N'e65d9baa-d737-4de9-a005-2f1f8f6263c8' or UID_ESetType=N'83b1694a-1d6c-4fb8-a5ea-f3f0e0d58e1d'");
 var entityRead = await qr.Session.Source().GetCollectionAsync(qEsets, ct).ConfigureAwait(false); 
 The "Api0015;Await construct is missing ..." error in the API Designer was caused by wrong order of brackets. (The API Designer isn't showing that issue as the Visual Studio would).

Hanno Bunjes · Answer

HandleGetBySqlStatement uses a fixed result type, so you would have to use the generic HandleGet variant to execute the predefined SQL statement. It would look similar to this: Method.Define("some_method") .HandleGet(async (request, ct) => { var session = request.Session; var result = await session.Resolve().SqlExecuteAsync("", new[] { new QueryParameter("", ValType.String, "Some_ParameterValue>") }, ct).ConfigureAwait(false); using (result) { while (result.Read()) { // ... process each data row } } return result_object; } } Make sure to include the "using" keyword, otherwise an open data reader will cause subsequent SQL statements to fail.

Endpoint Privilege Management

CompositionAPI independent Datatypes

Top Replies