topic Re: WITH CONNECTION + POST method + custom body message in App Development

WITH CONNECTION + POST method + custom body message

Thu, 29 Dec 2016 08:04:40 GMT

Hi everyone,

I am looking for a working example of a REST connection using the WITH CONNECTION + POST method + a custom body message.

The online manual shows the following only "as far as I can see":

WITH CONNECTION(Url "https://content.googleapis.com/calendar/v3/calendars/primary/events?key=AIzaS...");

But nothing about how the syntax looks like if we want to add a POST and a body message in the case of a REST connection for example.

Any feedback will be very much appreciated

Regards, Youness

Re: WITH CONNECTION + POST method + custom body message

Fri, 06 Jan 2017 07:42:03 GMT

Hello everyone,

I got help with my query and here I am sharing the code snippet:

Dummy:

SQL SELECT

FROM CSV (header off, delimiter ",", quote """") "CSV_source"

WITH CONNECTION (

URL "https://hooks.mysite.com/services/XYZXYZXYZ/ETC",

HTTPHEADER "Content-Type" "application/json",

BODY "{""text"": ""Posting from loadscript""}"

);

Enjoy and thumbs up for Alex Karlsson

// Youness

Re: WITH CONNECTION + POST method + custom body message

alis2063 — Thu, 18 Jul 2019 14:58:58 GMT

Can we add table fields in "with connection" body so in Email body it should be reflect as below

ID Amount

23,10000

with connection (
QUERY "to" "v@gmail.com "
,QUERY "message" "Total Sales greater than >20000 for $(vID)"
//,QUERY "subject" "$(vID)"
,QUERY "fromName" "NoReply"
,QUERY "fromEmail" "v@hotmail.com"

)

Re: WITH CONNECTION + POST method + custom body message

QFabian — Fri, 09 Oct 2020 19:59:46 GMT

excelent!!!, works for me!! thanks