---
editLink: false
lastUpdated: false
---

[@salesforce/b2c-tooling-sdk](../../../modules.md) / [operations/cip](../index.md) / buildCipReportSql

# Function: buildCipReportSql()

> **buildCipReportSql**(`name`, `params`): [`CipReportSqlResult`](../interfaces/CipReportSqlResult.md)

Defined in: [packages/b2c-tooling-sdk/src/operations/cip/index.ts:178](https://github.com/SalesforceCommerceCloud/b2c-developer-tooling/blob/e7c16f1ae423da0aa47b3e10be88f9770b53619b/packages/b2c-tooling-sdk/src/operations/cip/index.ts#L178)

Builds SQL for a curated report after validating provided parameters.

## Parameters

### name

`string`

### params

`Record`\<`string`, `string`\>

## Returns

[`CipReportSqlResult`](../interfaces/CipReportSqlResult.md)