Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DeepL API Just Loading for a long time #17

Open
bcsaba23 opened this issue May 16, 2023 · 1 comment
Open

DeepL API Just Loading for a long time #17

bcsaba23 opened this issue May 16, 2023 · 1 comment

Comments

@bcsaba23
Copy link

Hello all,

I have a sheet with a huge number of character that I want to translate it. Escpecially I have 34.000.000 pcs character in my sheet. I just set up the DeepL API and put the DeepL translate function all of the cells. Since Monday DeepL function is still loading and I dont see any succesfull translated charachter in my sheet. But I see a lot of fault message "Service invoked too many times for one day: urlfetch"

Yes I know this is a huge number of characters, but I didnt know how the API will handle it.

What should I do to translate my huge number of character? Could you help me please?

Thanks!

@JanEbbing
Copy link
Member

JanEbbing commented May 17, 2023

Hi, the error you're seeing means you're making too many HTTP requests and Google is in essence rate-limiting you (see here).

If you want to translate a big table like this, I would recommend to do it in steps, and not all cells at once (and wait until each set of cells is completed before starting the next one). Please note that a single cell can at most have in the order of 120k characters and still be translated successfully (as the maximum request size is 128kB, see docs)

If this is not a one-off job, I would strongly recommend using the API itself programmatically to achieve this. We have SDKs for various programming languages on this GitHub, this GSheets integration is just an example project of what you can build with the DeepL API, and we don't fully support it.

Edit: Also, the API can't yet handle huge requests, so if you didn't get a response within a minute, it's fair to assume the request just failed. No need to wait for hours.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants