I’ve spent all day searching for my answer on your FME Q&A; Forum but couldn’t find right answer for me. What I like to achieve.
1. Read file names only with extension .json from specific folder
2. Get list of file names from URL using HTTPCaller
3. Check to see if each file names are contained in list
4. If file exist,
- Increment counter for update
5. If file does not
- Increment counter for create
5. Once all the records are processed, then
- Create email content (2 lines)as follow:
# of records updated: xxx (counter)
# of records created: xxx (counter)
6. Sends Email – replaced with inspector for now.
I tried adding Aggregator before I sent email but it doesn’t preserve counter information.
I have attached working workbench and will also post it to FME Q&A; Forum.
Thank you
