Reply to thread

Message

<blockquote data-quote="robert54" data-source="post: 184701" data-attributes="member: 69596">I never have learned error trapping in T-SQL. Darn. Sometimes curl.xget in[CODE=vbnet]SELECT @JSON = curl.xget(null, ''+@GETSTRING+'')INSERT INTO [pcrd].[stg1_fredSeries]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ([SeriesCode]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ,[realStartTime]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ,[realEndTime]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ,[observationDate]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ,[observationValue]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ,[etl_dateUpdate]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ,[ETL_UserUpdate]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ,fk_series_id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ,api_url)&nbsp; &nbsp; SELECT&nbsp; &nbsp; &nbsp; &nbsp; @SERIES_CODE AS SeriesID,&nbsp; &nbsp; &nbsp; &nbsp; *,&nbsp; &nbsp; &nbsp; &nbsp; GETDATE() AS etl_dateUpdate,&nbsp; &nbsp; &nbsp; &nbsp; 'sp_get_fredSeriesPCTpe4' AS etl_userUpdate,&nbsp; &nbsp; &nbsp; &nbsp; @api_type,&nbsp; &nbsp; &nbsp; &nbsp; @GETSTRING&nbsp; &nbsp; FROM&nbsp; &nbsp; &nbsp; &nbsp; OPENJSON(@JSON,'$.observations') [/CODE]Throws an error:[CODE=vbnet]Msg 6522, Level 16, State 1, Procedure pcrd.sp_get_fredSeriesPCType4, Line 72 [Batch Start Line 20]A .NET Framework error occurred during execution of user-defined routine or aggregate &quot;XGET&quot;:System.Net.WebException: The remote server returned an error: (400) Bad Request.System.Net.WebException:at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest&amp; request)at System.Net.WebClient.DownloadString(Uri address)at Curl.Get(SqlChars H, SqlChars url)[/CODE]Is this just a matter or raising an error and looking for Msg 6522? This insert and the building of the @GETSTRING is in a cursor fetch. Can there be a BEGIN TRY in a cursor fetch? Assuming this is the way to go.</blockquote>

[QUOTE="robert54, post: 184701, member: 69596"] I never have learned error trapping in T-SQL. Darn. Sometimes curl.xget in [CODE=vbnet]SELECT @JSON = curl.xget(null, ''+@GETSTRING+'') INSERT INTO [pcrd].[stg1_fredSeries] ([SeriesCode] ,[realStartTime] ,[realEndTime] ,[observationDate] ,[observationValue] ,[etl_dateUpdate] ,[ETL_UserUpdate] ,fk_series_id ,api_url) SELECT @SERIES_CODE AS SeriesID, *, GETDATE() AS etl_dateUpdate, 'sp_get_fredSeriesPCTpe4' AS etl_userUpdate, @api_type, @GETSTRING FROM OPENJSON(@JSON,'$.observations') [/CODE] Throws an error: [CODE=vbnet]Msg 6522, Level 16, State 1, Procedure pcrd.sp_get_fredSeriesPCType4, Line 72 [Batch Start Line 20] A .NET Framework error occurred during execution of user-defined routine or aggregate "XGET": System.Net.WebException: The remote server returned an error: (400) Bad Request. System.Net.WebException: at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request) at System.Net.WebClient.DownloadString(Uri address) at Curl.Get(SqlChars H, SqlChars url)[/CODE] Is this just a matter or raising an error and looking for Msg 6522? This insert and the building of the @GETSTRING is in a cursor fetch. Can there be a BEGIN TRY in a cursor fetch? Assuming this is the way to go. [/QUOTE]

Verification