Rest API to convert JSON to Excel and return Response to Requester
Would like to take the results of an Ultra Task API request and return results in Excel Document instead of JSON. Anyone done this or have any ideas?
Forum Discussion
hi @robin. the catch is (that i probably should have mentioned) is i am grouping the rows by the OwnerEmail b/c further down the pipeline I email the user 1 single email with an HTML Table email snap. The table loops through the $group variable. While the Group By Fields I set the OwnerName like so… the subgrouping $groupBy still contains the field that I grouped by that I don’t want in the html table in the email.
here is what my json looks like (i blurred out the real emails but you can see the structure and the group part where i want to remove the owneremail value):
Hi @Marley_Bacelar,
File browser only it will give you some information about the files/objects you got in S3. You have couple of options here. You can use following snap packs:
- S3 snap pack.
- Binary snap pack (Directory Browse and File Reader)
- Or you can combine (but for this you will need to maintain multiple accounts)
Example with s3 snap pack (approach for binary will be similar) and also depending of the file formats your overall logic will be:
S3 file browser → S3 Download (this snap because you will need to maintain only one account) → Parser → mapper → router → insert.Thanks,
Pero M.
