Back to All Datasets
Salesforce Test Payload

Mock Salesforce Account Export JSON

A mock JSON payload simulating a Salesforce REST API response for Accounts, including sub-queries for Contacts and Opportunities. Use this payload to test JSON flattening, data loading pipelines, or database seeding.

Struggling to convert your own JSON?

Don't write another Python script. Use our free, 100% secure client-side tool to flatten any complex JSON export into a perfect Excel file in seconds.

Data never leaves your browser window.
Repair Your Export
payload.json
{
  "totalSize": 2,
  "done": true,
  "records": [
    {
      "attributes": {
        "type": "Account",
        "url": "/services/data/v58.0/sobjects/Account/001XXX0000001"
      },
      "Id": "001XXX0000001",
      "Name": "Acme Corp",
      "Industry": "Manufacturing",
      "AnnualRevenue": 50000000,
      "Contacts": {
        "totalSize": 2,
        "done": true,
        "records": [
          {
            "attributes": {
              "type": "Contact",
              "url": "/services/data/v58.0/sobjects/Contact/003XXX0000001"
            },
            "Id": "003XXX0000001",
            "FirstName": "John",
            "LastName": "Smith",
            "Title": "CEO"
          }
        ]
      },
      "Opportunities": {
        "totalSize": 1,
        "done": true,
        "records": [
          {
            "attributes": {
              "type": "Opportunity",
              "url": "/services/data/v58.0/sobjects/Opportunity/006XXX0000001"
            },
            "Id": "006XXX0000001",
            "Name": "Acme Q3 Order",
            "StageName": "Closed Won",
            "Amount": 150000
          }
        ]
      }
    }
  ]
}

Dataset Size

1161 Bytes

Format

JSON (Nested)

License

MIT (Free to use)