Report Names

Hellos,

Short Question 
How to define File Name , when we the only parameter being provided is logID
suppose we want the file name to be candidate_ID , do I then use URL logger to pass another parameter o while activating package or  there is another way 

Long Question
This is in context to  www.etl-tools.com/forum/advanced-etl-pro...ages-to-reports.html

We use below SQL to define the table , and the only parameter we provide in package is  id  using, begin  SetVariable('<EventId>',CommandLineParameter(2));  Result:=True; end;

DECLARE @json NVarChar(max)
select top 1 @json=text_field_02 from event_log 

select * from OpenJson(@json)
WITH ("candidate _ID" VARCHAR(100) '$."candidate _ID"',
"name" VARCHAR(100) '$.name',
"mobile" VARCHAR(100) '$.mobile',
"related_recruiter" VARCHAR(100) '$.related_recruiter',
"is_filled_by_recuriter" VARCHAR(100) '$.is_filled_by_recuriter',
"resume" VARCHAR(100) '$.resume',
"parent_entry_id" VARCHAR(100) '$.parent_entry_id',
"recruiter_email" VARCHAR(100) '$.recruiter_email',
"recruiter_name" VARCHAR(100) '$.recruiter_name',
"join_date" VARCHAR(100) '$.join_date',
"recruiter_code" VARCHAR(100) '$.recruiter_code'
)

 

As of now, I can get this to work by reading from JSON. Again the question is , is there a better / more efficient way

Script changes to 
begin  SetVariable('<EventId>',CommandLineParameter(2));  SetVariable('<offerid>',CommandLineParameter(3));  Result:=True; end;

File Name changes to <offerid>.pdf

URL Logger script singular change to 
const parameters = [objectId,logId,body["{{candidate_id}}"]];  

I think you are doing everything correctly