Documentation

PayloadForge documentation

A practical guide to configuring an API, importing spreadsheet data, mapping fields, cleaning incompatible values and generating validated requests.

On this page

1. Configure the target API

PayloadForge needs to understand the API request you want to create. You can configure the HTTP method, endpoint and request headers manually, or start from an existing cURL request.

Importing cURL is useful when you already have a working request from API documentation, another developer, a browser developer tool or an API client.

curl --request POST \
  --url 'https://api.example.com/v1/companies' \
  --header 'Authorization: Bearer {{API_TOKEN}}' \
  --header 'Content-Type: application/json'

2. Define the target data structure

The target structure describes the fields expected by the API. An example JSON object can be used to infer field names and basic data types.

{
  "company_name": "Microsoft",
  "country_code": "US",
  "revenue": 245000,
  "active": true
}

PayloadForge currently works with basic values such as strings, numbers, booleans and null values. Richer schema constraints are planned for future versions.

3. Import spreadsheet data

CSV data can be imported into the Request Data table. Each source column becomes a column PayloadForge can map to the target API, while each row represents one output object.

namecountryrevenueactive
AppleUS₹3,83,000Yes
SonyJapan85000true

4. Map spreadsheet columns to API fields

Spreadsheet headers and API property names frequently differ. Mapping tells PayloadForge which source value belongs in each target field.

name → company_name
country → country_code
revenue → revenue
active → active

Straightforward names can be matched automatically. Mappings that cannot be established safely remain available for manual selection.

5. Set the expected data type

A value that looks acceptable in a spreadsheet may still be invalid for an API. For example, the text₹3,83,000is not directly a JSON number.

PayloadForge validates values against the configured field type before generating the final request.

6. Build transformation pipelines

Transformations clean or normalize source values before type conversion and final validation. Multiple rules can be combined into an ordered pipeline.

Trim whitespace
Remove text
Replace text
Uppercase
Lowercase
Default value

For example,₹3,83,000can be transformed by removing the currency symbol and comma separators before converting the result to a number.

7. Review dataset impact

A rule that fixes one row may fail on another. PayloadForge therefore evaluates the transformation pipeline across the entire column.

Dataset Impact reports how many rows are valid, how many remain invalid and sample transformed values. Invalid rows are prioritized so problems can be found quickly.

Analyzed

500

Valid

487

Invalid

13

8. Use smart cleanup suggestions

PayloadForge can detect common formatting patterns and propose transformations that improve the dataset.

Numeric suggestions can identify currency symbols, thousands separators and surrounding whitespace. Boolean suggestions can normalize common labels such as Yes, No, Active, Inactive, Enabled and Disabled.

Suggested cleanup

Normalize boolean values

Replace "Yes" → "true"
Replace "Disabled" → "false"

Current: 2 / 4 valid → After: 4 / 4 valid

Suggestions are simulated before they are applied. A proposed cleanup must improve validation before it is presented as a useful suggestion.

9. Resolve validation errors

PayloadForge checks field mappings and transformed values before the request is considered ready. Invalid number or boolean values are surfaced with the row and field responsible for the problem.

Row 1, "revenue" must be a number.

10. Generate JSON and cURL

When the request is valid, PayloadForge generates typed JSON and a cURL representation using the configured HTTP method, endpoint and headers.

[
  {
    "company_name": "Apple",
    "country_code": "US",
    "revenue": 383000,
    "active": true
  }
]

Ready to try it?

Open the builder with your own API request and spreadsheet data, or continue with one of the practical guides.