AWS Lambda access file with relative path

Question

I am trying to access a relative file(which I need to put there accessible to Lambda) So that I could change the content of that file and send the response as part of API gateway response. I am able to generate an entirely new .xlsx file and send to the client. But the requirement is to change the content of given .xls (from filesystem relative path).

let XlsxPopulate = require('xlsx-populate');
exports.handler = async (event, ctx, cb) => {

    XlsxPopulate.fromFileAsync('./sample.xlsx')
                .then(workbook => {
                    //.... Modfy content
                    return {
                           statusCode: 200,
                           headers: {
                               'access-control-allow-origin': '*',
                           },
                           body: modifiedWorkbook,
                           isBase64Encoded: true
                       }
        });
};

@Mukund How can I put the file in temp in the first place ? How can I put my xls file at ./tmp/sample.xlsx — mbarish-me
– mbarish-me, Commented May 11, 2018 at 6:36
if u download the excel from S3 , download it to the /tmp location. If you are creating an new excel, create it in the /tmp/ folder remove the dot, it should be /tmp/sample.xlsx — Mukund
– Mukund, Commented May 11, 2018 at 6:40

Yogesh_D · Accepted Answer · 2018-05-11 08:16:15Z

1

An AWS Lambda only has access to /tmp and this location is limited to 512 MB. See https://docs.aws.amazon.com/lambda/latest/dg/limits.html.

However do not that Lambda functions are supposed to be stateless, don't count on having storing anything and having it accessible in the next call as the Lambda functions instance might be diff.

A good strategy would be to put the files in S3 and modify them locally.

As @Mukund mentioned as you can copy from S3 to /tmp and update them locally and then upload back to S3.

answered May 11, 2018 at 8:16

Yogesh_D

19k10 gold badges46 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

AWS Lambda access file with relative path

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related