[WIP Guide] JSON to PDF to cloud storage

It is very unusual JSON pair  "{{mobile}}": "09562312563".
It should be "mobile": "09562312563",
Is this coming from our software?  

admin wrote:

It is very unusual JSON pair  "{{mobile}}": "09562312563".
It should be "mobile": "09562312563",
Is this coming from our software?  

No sadly that's how we configured it in gravity forms , it was to show the team usage of {{ }} variables. 

This is part I of the video here we 

1. Configure URL logger to receive webhook
2. Test with a script
3. Run command line to ensure our items are working

LOOM VIDEO
 
Running Via Command line
"C:\\Program Files\\DB Software Laboratory\\Advanced ETL Processor Enterprise\\aetlcl.exe" 7405 1a6db230-baab-434b-a598-ac8edba02021 MYAWESOMEPDF
Change 7405 -> Your Package ID
String 1a -> Your event_log ID

Team ETL , any feedback on this?

Part II
1. Loading Data in SQL 
2. Creating Report
3. Creating paramters
4. Loading report

LOOM VIDEO

chatgpt prompt
DECLARE @json NVarChar(max)
select top 1 @json=text_field_02 from event_log where id =:sqlparamater;

SELECT * FROM OpenJson(@json)
WITH (
  "mobile" VARCHAR(100) '$."{{mobile}}"',
  "candidate_ID" VARCHAR(100) '$."{{candidate_id}}"',
  "candidate_name" VARCHAR(100) '$."{{candidate_name}}"',
  "candidate_address" VARCHAR(100) '$."{{candidate_address}}"',      
  "candidate_position" VARCHAR(100) '$."{{candidate_position}}"',
  "candidate_ctc" VARCHAR(100) '$."{{candidate_ctc}}"',
  "join_date" VARCHAR(100) '$."{{join_date}}"',
  "join_company" VARCHAR(100) '$."{{join_company}}"',
  "company_address" VARCHAR(200) '$."{{company_address}}"',
  "company_logo" VARCHAR(100) '$."{{company_logo}}"',      
  "appointment_id" VARCHAR(100) '$."{{appointment_id}}"'
)

Using above references as a template , adapt above code to include following fields and give me the new SQL code. I am using SQL 2019 and above code works. Remove the fields not relevant and add the ones which are . 


 

I must admit that your videos are much better than ours.  .

It is always good to see our customers succeed. 

Can we ask to add URL logger and AETL link to the video comments