Post exemptions from CSV

Testing

POST

https://eoj2l4j5inagjie.m.pipedream.net

This endpoint processes a CSV file for creating exemptions. The uploaded CSV file is validated for required columns, and exemptions are created for valid data. It provides a detailed response with success, errors, and skipped data.

The uploaded CSV must contain the following columns:

externalId: Unique identifier for the customer. (Example: 100325)
state: Full state name (case insensitive). (Example: Texas)
startdate: Start date for the exemption. (Example: 2024-09-01)
enddate: End date for the exemption. (Example: 2024-12-31)
source: Source name mapped to your system. (Example: netsuite / xero / priority...)

Request Example

Shell

JavaScript

Java

Swift

curl --location --request POST 'https://eoj2l4j5inagjie.m.pipedream.net' \
--header 'Authorization;' \
--header 'Content-Type: multipart/form-data' \
--form 'csvFile=@""'

Response Example

200 - Success

{
  "status": "success",
  "message": "All exemptions processed successfully.",
  "success_count": 35,
  "not_found_customers": [],
  "skipped_states": [],
  "errors": []
}

Request

Authorization

Provide your bearer token in the

Authorization

header when making requests to protected resources.

Example:

Authorization: Bearer ********************

Header Params

Authorization

string

required

Bearer token for authentication (format: Bearer )

Content-Type

string

required

Must be multipart/form-data

Example:

multipart/form-data

Body Params multipart/form-data

csvFile

file

required

The CSV file to upload. Must include valid columns as described below.

Responses

🟢200OK

application/json

Body

status

string

required

message

string

required

success_count

integer

required

not_found_customers

array[string]

required

skipped_states

array[string]

required

errors

array[string]

required

🟢206OK

🟠400Bad Request

Modified at 2025-03-31 13:23:20

Vat Validation

Xero - Integration & User Manual