-1

I have to pull some large amount of data from shopify through api2cart API. I need to pull data for 2/3 years back, which takes hours to pull as we can only pull 250 items per request. With each response, it provides a key to next 250 data pull and so on.

In my backend, I'm pulling data and saving it in a csv file through fs and then I call the api again for next 250 items. it works well on my local machine. the process continues untill all the data are fetched. I can pull years of data and it takes about 2-3 hours to pull about 100k/150k data.

Then I set up a NestJS Microservice and deployed on a digital ocean server. But when I make an API request for long time, after a few time, server gives me a 504 Gateway timeout Error.

Can't use the setTimeout as there' no limit to this process. is there any way to keep pulling data for hours or days?

What to do to pull data for hours without any 504 Gateway timeout Error?

Meraj Kazi
  • 65
  • 10
  • there's not much you can do, as the asker of this [question](https://stackoverflow.com/questions/71435551/http-504-error-program-not-getting-error-back) from March,11 also can not do anything about not getting an answer. When the process is not in the mood for giving answers you will not get an answer (besides the 504) – Luuk Apr 21 '22 at 07:29
  • Maybe get in touch with the owner of the data and ask them to send the data on [floppy](https://en.wikipedia.org/wiki/Floppy_disk) ? ('floppy' is the general term here for: "different media" ) – Luuk Apr 21 '22 at 07:31

2 Answers2

1

Very long running requests are in general error-prone. A connection reset could result in restarting the whole process again. Even though this won't fix the underlaying problem you described with digital ocean, I think it's worth you consider a different solution. I recommend to split up your heavy, long-running task into many small tasks and use a queue system.

Nestjs provides a very good documentation using queues and the bull package.

I added a basic example, with two solutions:

Queue consumer

shopify.consumer.ts

import { Processor, Process } from '@nestjs/bull';
import { Job } from 'bull';

@Processor('shopify')
export class ShopifyConsumer {
  constructor(
    private shopifyService: ShopifyService
  ) {}

  @Process('fetch')
  async transcode(job: Job<unknown>) {
    await this.shopifyService.fetch(job.requestKey);
  }
}

Option a) Generate all requests at once and let the queue process them:

shopify.service.ts

import { Injectable } from '@nestjs/common';
import { Queue } from 'bull';
import { InjectQueue } from '@nestjs/bull';

@Injectable()
export class ShopifyService {
  constructor(
    @InjectQueue('shopify') private shopifyQueue: Queue
  ) {}
    
  generateJobs(requestKeys: string[]) {
    for (const requestKey of requestKeys) {
      await this.shopifyQueue.add('fetch', { 
        requestKey
      });
    }
  }

  fetch(requestKey: string) {
    // Fetch data
    const res = await fetch('...')
  }
}

Option b) Generate a new queue job after every response

shopify.service.ts

import { Injectable } from '@nestjs/common';
import { Queue } from 'bull';
import { InjectQueue } from '@nestjs/bull';

@Injectable()
export class ShopifyService {
  constructor(
    @InjectQueue('shopify') private shopifyQueue: Queue
  ) {}

  fetch(requestKey: string) {
    // Fetch data
    const res = await fetch('...')
    
    // Add next job to queue if more chunks are available
    if (res.nextRequestKey) {
      await this.shopifyQueue.add('fetch', { 
        requestKey: res.nextRequestKey
      })
    }
  }
}
Korbinian Kuhn
  • 726
  • 4
  • 9
0

Queues and Bull work well with NestJS, and I would recommend them for these long calls. It is really helpful as you can also retry calls, and add a timeout for failed jobs (to help with 417 errors).

import { Injectable } from '@nestjs/common';
import { Queue } from 'bull';
import { InjectQueue } from '@nestjs/bull';

@Injectable()
export class ShopifyService {
  constructor(
    @InjectQueue('shopify') private shopifyQueue: Queue
  ) {}
    
  async generateJobs(requestKeys: string[]) {

    await this.shopifyQueue.addBulk('${QUEUE_NAME}.${JOB_NAME}', { 
      ...jobData //what is needed to make API call
    },
    {
      attempts: 5,
      backoff: 5000,
      //Will try 5 times with backoff
    });
  }
}
    ```
moogs
  • 81
  • 3