Create intake ppp loan import

Import SBA PPP/7(a) loan rows as a free payroll-derived revenue proxy: PPP loans were sized at 2.5x monthly payroll, and payrollToRevenueRatio (default 0.30) turns that into an estimated monthly volume. Matches existing customers on externalId “sba-ppp:<loanId>” or case-insensitive business name + street address; writes loan facts and the derived figures to customFields, records a sba_ppp revenue_estimate signal, and re-ranks.

POST/workspaces/{organizationId}/intake/ppp-loans/import

Authorization

AuthorizationBearer token · headerrequired

Workspace API key (Authorization: Bearer <key>). Issue keys under Settings → Developer or POST /workspaces/{organizationId}/tokens.

Path parameters

organizationIdstringrequired

Request body

application/json

loansobject[]required

Show properties

Array of object

loanIdstring | null

businessNamestringrequired

min length 1

addressstring | null

citystring | null

statestring | null

zipstring | null

loanAmountDollarsnumber | null

loanAmountCentsnumber | null

jobsReportednumber | null

naicsCodestring | null

approvalDatestring | null

loanTypestring

Allowed:ppp7a

payrollToRevenueRationumber

max 1

Responses

200

SBA loans imported

importedintegerrequired

createdintegerrequired

updatedintegerrequired

customersobject[]required

Show properties

Array of object

idstringrequired

namestringrequired

loanAmountCentsnumber | nullrequired

estMonthlyPayrollCentsnumber | nullrequired

estMonthlyVolumeCentsnumber | nullrequired

jobsReportednumber | nullrequired

scorenumber | nullrequired

400

Invalid request

Try it

Server

Base URLCustom base URLOverrides the selected server when set.

Authorization

Bearer tokenRemember on this deviceInclude my values in samples

Parameters

organizationIdpath*

Bodyapplication/json

Request body

Request

curl -X POST 'https://pile.nyc/workspaces/string/intake/ppp-loans/import' \
  -H 'Authorization: Bearer YOUR_TOKEN' \
  -H 'Accept: application/json' \
  -H 'Content-Type: application/json' \
  -d '{
  "loans": [
    {
      "loanId": "string",
      "businessName": "string",
      "address": "string",
      "city": "string",
      "state": "string",
      "zip": "string",
      "loanAmountDollars": 0,
      "loanAmountCents": 0,
      "jobsReported": 0,
      "naicsCode": "string",
      "approvalDate": "string",
      "loanType": "ppp"
    }
  ],
  "payrollToRevenueRatio": 1
}'

const response = await fetch("https://pile.nyc/workspaces/string/intake/ppp-loans/import", {
  method: "POST",
  headers: {
    "Authorization": "Bearer YOUR_TOKEN",
    "Accept": "application/json",
    "Content-Type": "application/json"
  },
  body: "{\n  \"loans\": [\n    {\n      \"loanId\": \"string\",\n      \"businessName\": \"string\",\n      \"address\": \"string\",\n      \"city\": \"string\",\n      \"state\": \"string\",\n      \"zip\": \"string\",\n      \"loanAmountDollars\": 0,\n      \"loanAmountCents\": 0,\n      \"jobsReported\": 0,\n      \"naicsCode\": \"string\",\n      \"approvalDate\": \"string\",\n      \"loanType\": \"ppp\"\n    }\n  ],\n  \"payrollToRevenueRatio\": 1\n}"
});

import requests

response = requests.post(
    "https://pile.nyc/workspaces/string/intake/ppp-loans/import",
    headers={
        "Authorization": "Bearer YOUR_TOKEN",
        "Accept": "application/json",
        "Content-Type": "application/json"
    },
    data="{\n  \"loans\": [\n    {\n      \"loanId\": \"string\",\n      \"businessName\": \"string\",\n      \"address\": \"string\",\n      \"city\": \"string\",\n      \"state\": \"string\",\n      \"zip\": \"string\",\n      \"loanAmountDollars\": 0,\n      \"loanAmountCents\": 0,\n      \"jobsReported\": 0,\n      \"naicsCode\": \"string\",\n      \"approvalDate\": \"string\",\n      \"loanType\": \"ppp\"\n    }\n  ],\n  \"payrollToRevenueRatio\": 1\n}",
)

Response

{
  "imported": 0,
  "created": 0,
  "updated": 0,
  "customers": [
    {
      "id": "string",
      "name": "string",
      "loanAmountCents": 0,
      "estMonthlyPayrollCents": 0,
      "estMonthlyVolumeCents": 0,
      "jobsReported": 0,
      "score": 0
    }
  ]
}