Download Bulk Upload Template

Download bulk upload template

curl --request GET \
  --url https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template \
  --header 'x-api-key: <api-key>'

import requests

url = "https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template"

headers = {"x-api-key": "<api-key>"}

response = requests.get(url, headers=headers)

print(response.text)

const options = {method: 'GET', headers: {'x-api-key': '<api-key>'}};

fetch('https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "x-api-key: <api-key>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("x-api-key", "<api-key>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.get("https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template")
  .header("x-api-key", "<api-key>")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["x-api-key"] = '<api-key>'

response = http.request(request)
puts response.read_body

"<string>"

GET

genebrc

bulk-upload

template

Download bulk upload template

curl --request GET \
  --url https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template \
  --header 'x-api-key: <api-key>'

import requests

url = "https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template"

headers = {"x-api-key": "<api-key>"}

response = requests.get(url, headers=headers)

print(response.text)

const options = {method: 'GET', headers: {'x-api-key': '<api-key>'}};

fetch('https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "x-api-key: <api-key>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("x-api-key", "<api-key>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.get("https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template")
  .header("x-api-key", "<api-key>")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["x-api-key"] = '<api-key>'

response = http.request(request)
puts response.read_body

"<string>"

Download a pre-filled Excel (.xlsx) template with all required and optional column headers and one example row. Use it as the starting point for a bulk upload. Column headers are matched to fields by name, so keep the header text unchanged. The file is named ebrc-bulk-upload-template.xlsx and the sheet is named EBRC Bulk Upload.

Request example

curl --request GET \
  --url 'https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template' \
  --header 'x-api-key: <YOUR_API_KEY>' \
  --output ebrc-bulk-upload-template.xlsx

Template columns

The template contains these 37 columns, in order, with the example row the file ships with:

Column header	Example row value
Serial No	`1`
Upload Type	`1`
Branch Sl No	`1`
IRM IFSC Code	`HDFC0001234`
IRM AD Code	`0510215`
IRM Number	`IRMNUMBER123`
IRM Date	`01/01/2024`
IRM FCC	`USD`
IRM Purpose Code	`P0102`
IRM Remit Amt FCC	`10000`
SB Cum Invoice Number	`INV/2024/001`
SB Cum Invoice Date	`01/01/2024`
Port Code	`INMAA1`
Bill No	`SB123456`
SB Cum Invoice FCC	`USD`
SB Cum Invoice Value In FCC	`10000`
Mapped IRM Amount FCC	`10000`
Is Vostro	`N`
Vostro Type
Mapped ORM Amount FCC
Is Third Party Export	`N`
Commission Val Deduct
Commission Val Info
Discount Val Deduct
Discount Val Info
Insurance Val Deduct
Insurance Val Info
Other Deduction Deduct
Other Deductions Info
Freight Val Deduct
Freight Val Info
SAC Code 1
SAC Code 2
Service Type Modes Value
Is GST Avail	`N`
GSTIN Invoice Number
GSTIN Invoice Date

Each column maps to the field of the same name in the Push IRM Request Fields annexure, which documents formats and constraints.

Valid codes

Purpose Codes for IRM Purpose Code
Currency Codes for IRM FCC and SB Cum Invoice FCC
Port Codes for Port Code

Next steps

Upload the filled file.
Want the template pre-filled with real IRM data? Use Load IRMs in Excel.

Authorizations

x-api-key

string

header

required

Response

200 - application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Excel template file (.xlsx)

The response is of type file.

Download eBRC PDF Bulk Upload via Excel

⌘I

​Request example

​Template columns

​Valid codes