Configuring a Query Job on the Juspay Dashboard

This guide helps you configure a Query Job from the Juspay Dashboard to automatically fetch transaction or settlement data from external sources like APIs, SFTP, or S3 for reconciliation.

Automate the ingestion of daily settlement files or transaction data to reconcile with Juspay’s records.

Prerequisites

Before setting up a Query Job, ensure the following:

• You have Dashboard access with reconciliation permissions.

• Your external data source (API/SFTP/S3) is registered and whitelisted with Juspay.

• A valid Connection ID (created by Juspay or your team) is available.

• The file schema matches the expected recon format.

Steps to Create a Query Job

Step 1

Navigate to the Query Jobs Section

• Log in to the Juspay Dashboard.

• Go to Reconciliation & Settlement Module » Configurator

• Select Query Jobs tab

• Click ➕ Add Query Job.

Step 2

Fill in the Query Job Configuration

Scroll inside to view more

Field	Description
Source	Choose the origin of your data:- API, SFTP
Connection ID
File Type	Format of incoming data:- CSV- JSON- XLSX
Payment Entity
Payment Sub-Entity
Enter Query / File Path	Core Query fetch logic

Expand

2 columns 7 rows

Step 3

Save and Submit

• Click Submit to save the configuration.

• The job will:

  • Run instantly if set as ad-hoc.

  • Run as per a defined schedule (if applicable).