Videos - Read JSON from Sql

prashant
Topic Author
Offline
Platinum Member

More

1 year 10 hours ago #25557 by prashant

Videos - Read JSON from Sql was created by prashant

Purpose of the series is to
Read a webhook
Read keypairs
Save each key pair to SQL

Introduction to Series
www.loom.com/share/feb92124f9b140c682063...4f-a4b1-43dc1c59f87a

Reading Static Record from SQL
www.loom.com/share/9b3430abc10b4945a41b4...47-b5bc-ce403b6cb367

Reading SQL record via passing SQL
www.loom.com/share/6daab8504b6749fe80a36...d6-8ff2-2dcf293fd9e4

Reading Via commandline- This video also explains AETL command line briefly
www.loom.com/share/15d2429c35ec41d490e8e...c0-8b56-476d47fb333a

Using JSON object to extract a specific property
www.loom.com/share/e2f5d15303f2481587d72...f9-bce5-70cdc0eb3d4b

Looping through JSON arrays to extract multiple json keyvalues
www.loom.com/share/0f973207579946258fc5c...dd-8d52-fd31311094c8

The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

prashant
Topic Author
Offline
Platinum Member

More

1 year 10 hours ago #25558 by prashant

Replied by prashant on topic Videos - Read JSON from Sql

To do
1. Extracting multiple key pairs and saving them as variable
2. Mapping each key pair into SQL

The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

prashant
Topic Author
Offline
Platinum Member

More

1 year 10 hours ago #25559 by prashant

Replied by prashant on topic Videos - Read JSON from Sql

SQL script static

Code:

SELECT '<json_variable>' AS variable_name,
       text_field_02 AS variable_value
FROM [url_logger].[dbo].[event_log]
WHERE id = '1dbe288c-ca7c-4abc-bebe-d25a9687f10f';

SQL use variables

Code:

SELECT '<json_variable>' AS variable_name,
       text_field_02 AS variable_value
FROM [url_logger].[dbo].[event_log]
WHERE id = '#eventid#;

The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

Peter.Jonson
Offline
Administrator

More

11 months 4 weeks ago #25583 by Peter.Jonson

Replied by Peter.Jonson on topic Videos - Read JSON from Sql

Thank you Prashant,
This will benefit a lot of users.

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

prashant
Topic Author
Offline
Platinum Member

More

11 months 4 weeks ago #25585 by prashant

Replied by prashant on topic Videos - Read JSON from Sql

Peter.Jonson wrote:
Thank you Prashant,
This will benefit a lot of users.

The idea about this series was to showcase some stuff which N8N does and we (AETL) can also easily do including webhooks , manipulation of data , and more. N8N seem to have exploded lately all YouTube. I hope the same happens to AETL

Please Log in or Create an account to join the conversation.

ETL Forum