Replacing {{placeholders}} in html file

Peter.Jonson
Offline
Administrator

More

2 years 3 weeks ago #23969 by Peter.Jonson

Replied by Peter.Jonson on topic Replacing {{placeholders}} in html file

I have attached a package for your convenience.

File Attachment:

File Name: Case40.zip
File Size:1 KB

Peter Jonson
ETL Developer

The following user(s) said Thank You: prashant

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

Peter.Jonson
Offline
Administrator

More

2 years 3 weeks ago #23970 by Peter.Jonson

Replied by Peter.Jonson on topic Replacing {{placeholders}} in html file

Another way of doing it is using transformation but this far too complex from my point of view

Peter Jonson
ETL Developer

The following user(s) said Thank You: prashant

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

prashant
Topic Author
Offline
Platinum Member

More

2 years 3 weeks ago - 2 years 3 weeks ago #23971 by prashant

Replied by prashant on topic Replacing {{placeholders}} in html file

Hi Peter,
Thank you this is most useful, thanks for taking the time to put this together for me.

I have another question , can I
1. Receive the variables as JSON via URL Logger?
1.5 pass the incoming JSON or logID to ETL
2. Pass the variables to above set package using another calculation ? (I don't know how to do this?)

Cheers,
PM

Last edit: 2 years 3 weeks ago by prashant.

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

prashant
Topic Author
Offline
Platinum Member

More

2 years 3 weeks ago #23973 by prashant

Replied by prashant on topic Replacing {{placeholders}} in html file

Updates

File operations are going to be very expensive , I need to define 1 for each replacement , easily 10-15 replacement can exists, so this would be very messy very quickly.

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

admin
Offline
Administrator
Deeds not Words

More

2 years 3 weeks ago #23974 by admin

Replied by admin on topic Replacing {{placeholders}} in html file

So in this case what Peter has already suggested would be a best option.

Mike
ETL Architect

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

prashant
Topic Author
Offline
Platinum Member

More

2 years 3 weeks ago #23975 by prashant

Replied by prashant on topic Replacing {{placeholders}} in html file

admin wrote:
So in this case what Peter has already suggested would be a best option.

In that scenario , can you guide me how to load variables from a json file with a calculation? Example JSON

Code:

{   "candidate _ID": "00157",   "name": "ujditjgio gyudbfh",   "mobile": "56321456985",   "position": "hr",   "related_recruiter": "portal",   "is_filled_by_recuriter": "",   "resume": "https://x/wp-content/uploads/gravity_forms/28-1f604683ffeab15f1793442dbe967e42/2024/06/CV_Rahul-1.pdf",   "parent_entry_id": false,   "recruiter_email": "priti@gmail.com",   "recruiter_name": "workindia",   "recruiter_code": "099" }

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

ETL Forum