hi team
i am using the following sql server version
Microsoft Azure SQL Data Warehouse – 10.0.33054.0 Jul 9 2024 00:12:38 Copyright (c) Microsoft Corporation
my college told me this is Azure Dedicated pool , but when i try this statement
SERVERPROPERTY(‘EngineEdition’) it gave me the value of 6

now the issue is :-
this is my code , which is the REST API is working fine from postman tool
——————————————————
DECLARE @URL NVARCHAR(255) = ‘https://date.nager.at/api/v3/PublicHolidays/2024/ZA‘
— HTTP Request Parameters
DECLARE @Object AS INT;
DECLARE @Hr INT;
DECLARE @JSONResponse as NVARCHAR(max);

——————————————————————————–
— Perform HTTP GET Request to endpoint
EXEC @Hr = sp_invoke_external_rest_endpoint
@url = @URL,
@method = ‘GET’,
@response = @JSONResponse output;

SELECT @Hr AS ReturnCode, @JSONResponse AS Response

———————————————————————
it gave me the following error :-

Msg 103010, Level 16, State 1, Line 1
Parse error at line: 10, column: 1: Incorrect syntax near ‘EXEC’.

any suggestions ????

​hi teami am using the following sql server versionMicrosoft Azure SQL Data Warehouse – 10.0.33054.0 Jul 9 2024 00:12:38 Copyright (c) Microsoft Corporationmy college told me this is Azure Dedicated pool , but when i try this statementSERVERPROPERTY(‘EngineEdition’) it gave me the value of 6now the issue is :-this is my code , which is the REST API is working fine from postman tool——————————————————DECLARE @URL NVARCHAR(255) = ‘https://date.nager.at/api/v3/PublicHolidays/2024/ZA’– HTTP Request ParametersDECLARE @Object AS INT;DECLARE @Hr INT;DECLARE @JSONResponse as NVARCHAR(max);———————————————————————————- Perform HTTP GET Request to endpointEXEC @Hr = sp_invoke_external_rest_endpoint@url = @URL,@method = ‘GET’,@response = @JSONResponse output;SELECT @Hr AS ReturnCode, @JSONResponse AS Response———————————————————————it gave me the following error :-Msg 103010, Level 16, State 1, Line 1Parse error at line: 10, column: 1: Incorrect syntax near ‘EXEC’. any suggestions ????   Read More

​