Consume Rest Service POST with interval

Anonymous — Thu, 30 Nov 2017 17:15:37 GMT

I consume the rest Service with connector of rest service, this rest service is post and need a token but the moment when execute code, send error

My body in connector is this

{

"interval": "2017-04-07T04:00:00.000Z/2017-04-08T04:00:00.000Z",

"groupBy": [ "queueId" ],

"timeZone": "America/Santiago"

}

and my code is

LIB CONNECT TO 'Indicadores';

LET vRequestBody ='';

LET vRequestBody = vRequestBody & '{"interval": "$(vFechaInicio)&'/'&$(vFechaFin)"&,"groupBy": [ "queueId" ],

"timeZone": "America/Santiago"}';

LET vRequestBody = replace(vRequestBody,'"', chr(34)&chr(34));

RestConnectorMasterTable:

SQL SELECT

"__KEY_results",

(SELECT

"mediaType",

"queueId",

"__FK_group"

FROM "group" FK "__FK_group"),

(SELECT

"interval",

"__KEY_data",

"__FK_data",

(SELECT

"metric",

"__KEY_metrics",

"__FK_metrics",

(SELECT

"max",

"min",

"count",

"sum",

"ratio",

"numerator",

"denominator",

"__FK_stats"

FROM "stats" FK "__FK_stats")

FROM "metrics" PK "__KEY_metrics" FK "__FK_metrics")

FROM "data" PK "__KEY_data" FK "__FK_data")

FROM JSON (wrap off) "results" PK "__KEY_results"

WITH CONNECTION (

HTTPHEADER "Authorization" "bearer $(vAccessToken2)",

BODY "$(vRequestBody)"

);

topic Consume Rest Service POST with interval in Integration, Extension & APIs

Consume Rest Service POST with interval