I’m wanting to create a scenario that pulls open Expensify reports from the last month that lists all the charges on each report. From that I would like to put it through an Array Iterator to filter out charges with receipts and group transactions by the user to send out missing receipts emails to individual users.
I’ve been able to connect my expensify account and get open reports from the last month. But I’m getting stuck on the Template section of the Module and wondering if anyone has experience with that? I tried using ChatGPT to make a Freemaker code but it keeps producing binary output. The first screenshot is the code given to me by ChatGPT, it’s simple but I’ll make it more complex as I understand the language better. The second screenshot is how the output is structured, and the third is how I would want the data to come out:
Welcome to the Make community!
Can ChatGPT really generate Freemaker code?
A. Plain text file?
If that “Data” is an actual plain text file we are looking at,
You can try using a “Convert encoding” module using the same input and output encoding, then you can use the output of this module in a subsequent module (like Parse CSV or JSON).
Alternatively, you can simply try using the toString built-in function in the mapped field, something like this: toString(data) .
B. Not Plain text file
If this is not a plain text file, use another file handling module like Google Drive’s “Upload a file” to send the file elsewhere, where you can download to your computer.
According to the Make documentation on Buffer (binary data),
File content is usually sent as Buffer type (image content, video file and others). In some cases, there is text data included in this type (e.g. text file). Make is able to automatically convert text data in binary code to text (and vice versa). For more information on working with files see the Working with files article.
For more information on how to map files (Binary Data), see https://www.make.com/en/help/mapping/working-with-files
2 Likes
Thank you that worked great!
I’m able to pull the data I need, but now I need to convert the long string into a data type that I can run through and iterator to break it up into bundles. Basically after each transaction is in a different bundle, I will filter out the transactions with receipt ID’s and then create arrays grouped by the User’s email to send out the emails. Would love to hear if there is a way to convert the string:
No problem, glad I could help!
That looks like a new question, could you try to create a new thread for this to get a response from another community expert? (This is because I’m already in bed and can’t provide a detailed example for you)
While it’s tempting to continue an existing thread, a more effective approach would be to start a new topic just for your question. It helps community experts find and respond to your query quicker, and keeps our space organised for everyone. If you start a new conversation you are also more likely to get help from other users. You can refer others back to a related topic by including that link in your question. Thank you for understanding and keeping our community neat and tidy.
1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
others can save time when catching up with the latest activity here, and
- allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
2 Likes
