HTTP Request -> bigQuery

Questions
,
1

hi

I want to store the some data from Business Central in bigQuery.
As there is no direct connector to BC, I think I have to use HTTP Request.
Can you tell me how should I do that? I don’t want to read all data and load everything into bigQuery - just the new data.
Is there any way to do incremental loading?

Thanks in advance
Regards
Krzysztof

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @Krzysztof_M

I guess you could work with a timestamp value and use that as a filter for the BC API?

4

Yes, I can do that. But I am a little afraid that if something happens and job won’t be executed - I will miss some data. That’s why I thought about incremental loading (and take eg. data from last 24 hours)

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.