Skip to main content

I am using Zapier platform cli to write a customised 'Create'. When I try to provide the path for big query service account key, I get the following error - ENOENT: no such file or directory, open '/var/task/creates/key.json'

const options = {
keyFilename: 'creates/key.json',
projectId: 'test',
};

const bigqueryClient = new BigQuery(options);

Can anyone help me please?

I tried to provide the json key directly in the keyFilename

Hi there @KritiS ,

Are you using the NodeJS Big Query library? You might try checking with that community. I don’t think using a file is going to work on the Zapier platform, so you might want to look into other ways of logging in, possibly by setting environment variables? I’m not sure, I don’t have any experience with that library.