received task error message

Status: Closed · Asked by lelehelloworld on · 0 views

lelehelloworld — Question ·

I am currently running a workflow named "PNL 新Bill - Xero to Sheet" and just received below task error details, what is the matter of this?

{
"error > code": 429,
"error > message": "Quota exceeded for quota metric \u0027Write requests\u0027 and limit \u0027Write requests per minute per user\u0027 of service \u0027sheets.googleapis.com\u0027 for consumer \u0027project_number:1011300378975\u0027.",
"error > status": "RESOURCE_EXHAUSTED",
"error > details > 0 > @type": "type.googleapis.com/google.rpc.ErrorInfo",
"error > details > 0 > reason": "RATE_LIMIT_EXCEEDED",
"error > details > 0 > domain": "googleapis.com",
"error > details > 0 > metadata > quota_metric": "sheets.googleapis.com/write_requests",
"error > details > 0 > metadata > quota_location": "global",
"error > details > 0 > metadata > consumer": "projects/1011300378975",
"error > details > 0 > metadata > quota_limit": "WriteRequestsPerMinutePerUser",
"error > details > 0 > metadata > service": "sheets.googleapis.com",
"error > details > 0 > metadata > quota_limit_value": "60",
"error > details > 1 > @type": "type.googleapis.com/google.rpc.Help",
"error > details > 1 > links > 0 > description": "Request a higher quota limit.",
"error > details > 1 > links > 0 > url": "https://cloud.google.com/docs/quota#requesting_higher_quota"
}

Himesh Soni — Reply ·

@lelehelloworld , your google api limits exceeded. You have exceeded limit of 60 request/minute. Try to use Delay action to avoid this error in future.

Automation Freelancer
Contact me - https://www.facebook.com/himeshsoni07
Email - [EMAIL][email hidden][/EMAIL]
lelehelloworld — Reply ·
@lelehelloworld , your google api limits exceeded. You have exceeded limit of 60 request/minute. Try to use Delay action to avoid this error in future.

I see, so does it mean if exceeded limit, the rest of the data from Xero would not been sync to google sheet? should I add the delay action between Xero and Google sheet. Thanks Himesh:)
Himesh Soni — Reply ·

Yeah you should add delay between Xero and google sheet.

Automation Freelancer
Contact me - https://www.facebook.com/himeshsoni07
Email - [EMAIL][email hidden][/EMAIL]

Back to all forum threads · Log in to reply