Rest connection "With connection" function

echildm — Wed, 12 Jul 2023 14:55:54 GMT

Hello everybody,

Im using rest connector to extract monetary indicators from central banks, i wanted to use one connector to extract diferent series but i get an error that I have not been able to fix, the code is the following:

LIB CONNECT TO 'BancoCentralMéxicoDólar';

// URL DOLAR: https://www.banxico.org.mx/SieAPIRest/service/v1/series/SF343410/datos

// ULR IPC: https://www.banxico.org.mx/SieAPIRest/service/v1/series/SP30577/datos

// token: d78e714795304daab6fbf34d4170fcecc1c5d6cc514182fde6a41d11db35b9d9

RestConnectorMasterTableDolarMexico:

SQL SELECT

"__KEY__response_header",

(SELECT

"__FK_bmx",

"__KEY_bmx",

(SELECT

"__FK_series",

"__KEY_series",

(SELECT

"fecha",

"dato",

"__FK_datos"

FROM "datos" FK "__FK_datos")

FROM "series" PK "__KEY_series" FK "__FK_series")

FROM (wrap off) "bmx" PK "__KEY_bmx" FK "__FK_bmx")

FROM JSON "_response_header" PK "__KEY__response_header";

Let vURL = 'https://www.banxico.org.mx/SieAPIRest/service/v1/series/SP30577/datos/';

RestConnectorMasterTableIpcMexico:

SQL SELECT

"__KEY_bmx",

(SELECT

"__FK_series",

"__KEY_series",

(SELECT

"fecha",

"dato",

"__FK_datos"

FROM "datos" FK "__FK_datos")

FROM "series" PK "__KEY_series" FK "__FK_series")

FROM JSON (wrap off) "bmx" PK "__KEY_bmx"

WITH CONNECTION (

URL "$(vURL)",

QUERY "token" "d78e714795304daab6fbf34d4170fcecc1c5d6cc514182fde6a41d11db35b9d9",

QUERY "formato" "JSON"

);

This is the error message:

The following error occurred:
(Connector error: HTTP protocol error 400 (Bad Request):

You typed an invalid character in one of the fields on the form. Please return to the previous screen and try the operation again.)
The error occurred here:

RestConnectorMasterTableIpcMexico:

SQL SELECT

"__KEY_bmx",

(SELECT

"__FK_series",

"__KEY_series",

(SELECT

"fecha",

"dato",

"__FK_datos"

FROM "datos" FK "__FK_datos")

FROM "series" PK "__KEY_series" FK "__FK_series")

FROM JSON (wrap off) "bmx" PK "__KEY_bmx"

WITH CONNECTION (

URL "$(vURL)",

QUERY "token" "d78e714795304daab6fbf34d4170fcecc1c5d6cc514182fde6a41d11db35b9d9",

QUERY "formato" "JSON"

If I try this with two different connections changing the URL's values and in this way it works correctly, but when i use the "with connection" function the error occurs ¿Any idea how to fix this?

Thanks in advance.

Re: Rest connection "With connection" function

Chirantha — Thu, 13 Jul 2023 07:59:05 GMT

Hey,

Please try removing the space character at the beginning of the ''vURL'' variable and see if it helps:

Let vURL = 'https://www.banxico.org.mx/SieAPIRest/service/v1/series/SP30577/datos/';

Re: Rest connection "With connection" function

echildm — Fri, 14 Jul 2023 16:54:11 GMT

I tried and still get the same error.

ps: thx for the try.

topic Re: Rest connection "With connection" function in Connectivity & Data Prep

Rest connection "With connection" function

Re: Rest connection "With connection" function

Re: Rest connection "With connection" function