Oct 04
Laurent G Webhook data extract (JSON?)
Oct 04, 2017; 10:11
Laurent G
Webhook data extract (JSON?)
Hi,
In order to remove hardbounced, I've created a webhook, which send
data to specific URL on my server. Raw data received on my server :
{"event":"hard_bounce","email":"example@example.com","id":43564,"date":"2017-10-04
15:49:55","ts":1507124995,"message-id":"<59d4e4c8819adc61c6011f75@domain.com>","ts_event":1507124995})
Then, I want to add those variables to my SQL database, but it does not work.
var('data_received')=Client_Params;
local('json') = var('data_received');
iterate(decode_json(#json), local('i'));
var('email') = #i -> find('email');
var('event') = #i -> find('event');
var('message-id') = #i -> find('message-id');
var('type') = #i -> find('type');
if( Valid_Email(var('email')) == True );
Inline( -Database='mydatabase',
-Table='hardbounced',
'email'=var('email'),
'event'=var('event'),
'message-id'=var('message-id'),
'type'=var('type'),
'date'=date_format(Server_Date, -format='%Q'),
-Add);
/Inline;
/if;
/iterate;
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Oct 04
Steve Piercy - Website Builder Re: Webhook data extract (JSON?)
Oct 04, 2017; 12:24
Steve Piercy - Website Builder
Re: Webhook data extract (JSON?)
Oct 04
Laurent G Re: Webhook data extract (JSON?)
Oct 04, 2017; 17:09
Laurent G
Re: Webhook data extract (JSON?)
Oct 04
Steve Piercy - Website Builder Re: Webhook data extract (JSON?)
Oct 04, 2017; 15:23
Steve Piercy - Website Builder
Re: Webhook data extract (JSON?)
Oct 05
Laurent G Re: Webhook data extract (JSON?)
Oct 05, 2017; 10:29
Laurent G
Re: Webhook data extract (JSON?)
Oct 05
Steve Piercy - Website Builder Re: Webhook data extract (JSON?)
Oct 05, 2017; 09:26
Steve Piercy - Website Builder
Re: Webhook data extract (JSON?)
Oct 05
Laurent G Re: Webhook data extract (JSON?)
Oct 05, 2017; 16:43
Laurent G
Re: Webhook data extract (JSON?)
Oct 05
Laurent G Re: Webhook data extract (JSON?)
Oct 05, 2017; 16:46
Laurent G
Re: Webhook data extract (JSON?)