Skip to Content
0
Jun 15 at 10:50 AM

SAP B1 for HANA - Service Layer SQLQuerie (V10-FP2102)

71 Views

Hi,

I create that SQL Querie

{
"SqlCode": "MySQL",
"SqlName": "GetMyArtigos - descrição nova 2",
"SqlText": "select T0.ItemCode, T0.ItemName, T0.ItmsGrpCod from OITM T0"
}

When you make GET ...SQLQuerie('MySQL') returns:

{

"@odata.context": "https://192.168.1.222:50000/b1s/v2/$metadata#SQLQueries/$entity",

"@odata.etag": "W/\"356A192B7913B04C54574D18C28D46E6395428AB\"",

"SqlCode": "MySQL", "SqlName": "GetMyArtigos - descrição nova 2",

"SqlText": "select T0.\"ItemCode\", T0.\"ItemName\", T0.\"ItmsGrpCod\" from \"OITM\" T0", "ParamList": null, "CreateDate": "2021-06-15", "UpdateDate": "2021-06-15"

}

Return of GET ...SQLQuerie('MySQL')/List

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html>
<head> <title>502 Proxy Error</title> </head>
<body> <h1>Proxy Error</h1> <p>The proxy server received an invalid response from an upstream server.<br/> The proxy server could not handle the request<p>Reason: <strong>Error reading from remote server</strong></p> </p> </body>
</html>

I suppose that therror was in SqlText syntaxe os HANA (Look in GET).

Any help?

Thanks