---
page_source: https://juspay.io/sea/docs/dashboard-sea/docs/recon--settlement/query-job
page_title: Query Job
---


# **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[](https://portal.juspay.in/)[Juspay Dashboard](https://portal.juspay.in/).
* Go to **Reconciliation & Settlement Module**  » **Configurator**
* Select **Query Jobs**  tab
* Click ➕ **Add Query Job.**



![Image](https://dth95m2xtyv8v.cloudfront.net/tesseract/assets/dashboard/Untitled%20design.jpg)
*Query Job Configuration*




### Step 2 Fill in the Query Job Configuration



| 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 |





### 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).**