# Sparse Update Invoice — QuickBooks Sandbox

> Sparse updating provides the ability to update a subset of properties for a given object; only elements specified in the request are updated. Missing elements are left untouched. The ID of the object to update is specified in the request…

- Key: `quickbooks_sandbox-sparse-update-invoice`
- Type: Action (Write)
- Version: 0.0.4
- App: QuickBooks Sandbox (`quickbooks_sandbox`) — https://pipedream.com/apps/quickbooks-sandbox.md
- This page (HTML): https://pipedream.com/apps/quickbooks-sandbox/actions/sparse-update-invoice
- Source: https://github.com/PipedreamHQ/pipedream/blob/master/components/quickbooks_sandbox/actions/sparse-update-invoice/sparse-update-invoice.mjs

## Description

Sparse updating provides the ability to update a subset of properties for a given object; only elements specified in the request are updated. Missing elements are left untouched. The ID of the object to update is specified in the request body.​ [See the documentation](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice#sparse-update-an-invoice)

## Props

| Prop | Type | Required | Description |
|---|---|---|---|
| `invoiceId` | `string` | Yes | ID of the invoice to get details of Options are loaded from the connected account. |
| `customer` | `string` | Yes | Reference to a customer or job Options are loaded from the connected account. |
| `currency` | `string` | No | A three letter string representing the ISO 4217 code for the currency. For example, USD, AUD, EUR, and so on. This must be defined if multicurrency is enabled for the company. Multicurrency is enabled for the company if Preferences.MultiCurrencyEnabled is set to true. Read more about multicurrency support here. Required if multicurrency is enabled for the company. Options are loaded from the connected account. |
| `lineItemsAsObjects` | `boolean` | Yes | Enter line items as an array of objects |

## Run it

**MCP**

```ts
import { Client } from "@modelcontextprotocol/sdk/client/index.js"
import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp.js"
import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const accessToken = await pd.rawAccessToken

const transport = new StreamableHTTPClientTransport(
  new URL("https://remote.mcp.pipedream.net/v3"),
  {
    requestInit: {
      headers: {
        Authorization: `Bearer ${accessToken}`,
        "x-pd-project-id": process.env.PIPEDREAM_PROJECT_ID!,
        "x-pd-environment": "production",
        "x-pd-external-user-id": "{external_user_id}", // any stable ID for this user in your system
        "x-pd-app-slug": "quickbooks_sandbox",
      },
    },
  },
)

const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)

const { tools } = await mcp.listTools()

// listTools() hands your model this tool's input schema, so it can
// fill the arguments itself:
const result = await mcp.callTool({
  name: "quickbooks_sandbox-sparse-update-invoice",
  arguments: {
    invoiceId: "Invoice ID",
    customer: "Customer Reference",
  },
})
```

**TypeScript**

```ts
import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "quickbooks_sandbox-sparse-update-invoice",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    quickbooks_sandbox: { authProvisionId: "apn_xxxxxxx" },
    invoiceId: "Invoice ID",
    customer: "Customer Reference",
  },
})

console.log(result)
```

**cURL**

```bash
curl -X POST https://api.pipedream.com/v1/connect/{project_id}/actions/run \
  -H "Content-Type: application/json" \
  -H "X-PD-Environment: production" \
  -H "Authorization: Bearer {access_token}" \
  -d '{
    "external_user_id": "{external_user_id}",
    "id": "quickbooks_sandbox-sparse-update-invoice",
    "configured_props": {
      "quickbooks_sandbox": { "authProvisionId": "apn_xxxxxxx" },
      "invoiceId": "Invoice ID",
      "customer": "Customer Reference"
    }
  }'
```

---

- App: https://pipedream.com/apps/quickbooks-sandbox.md · All apps: https://pipedream.com/apps