---
title: Preview transformer
---

[Skip to content](#_top)

[API Reference](https://developers.cloudflare.com/api/python)

[Logpush](https://developers.cloudflare.com/api/python/resources/logpush)

[Transformers](https://developers.cloudflare.com/api/python/resources/logpush/subresources/transformers)

Copy Markdown

Open in **Claude**Open in **ChatGPT**Open in **Cursor**

---

**Copy Markdown****View as Markdown**

# Preview transformer

logpush.transformers.preview(TransformerPreviewParams\*\*kwargs) -> SyncSinglePage\[[TransformerPreviewResponse](<https://developers.cloudflare.com/api/python/resources/logpush#(resource)%20logpush.transformers%20%3E%20(model)%20transformer_preview_response%20%3E%20(schema)>)]

POST/accounts/{account\_id}/logpush/transformers/preview

Executes a SQL transformer against a single input record and returns the transformed output. This is a stateless endpoint — nothing is persisted.

##### Security

<details>

<summary>API Token</summary>



The preferred authorization scheme for interacting with the Cloudflare API. <a href="https://developers.cloudflare.com/fundamentals/api/get-started/create-token/">Create a token</a>.

**Example:**<code>Authorization: Bearer Sn3lZJTBX6kkg7OdcBUAxOO963GEIyGQqnFTOFYY</code>

</details>

<details>

<summary>API Email + API Key</summary>



The previous authorization scheme for interacting with the Cloudflare API, used in conjunction with a Global API key.

**Example:**<code>X-Auth-Email: user@example.com</code>

The previous authorization scheme for interacting with the Cloudflare API. When possible, use API tokens instead of Global API keys.

**Example:**<code>X-Auth-Key: 144c9defac04969c7bfad8efaa8ea194</code>

</details>

##### Accepted Permissions (at least one required)

`Logs Write`

##### ParametersExpand Collapse

account\_id: str

Identifier.

maxLength32

[Link to this property](<#(resource)%20logpush.transformers%20%3E%20(method)%20preview%20%3E%20(params)%20default%20%3E%20(param)%20account_id%20%3E%20(schema)>)

input: Dict\[str, object]

A single log record to transform (JSON object).

[Link to this property](<#(resource)%20logpush.transformers%20%3E%20(method)%20preview%20%3E%20(params)%20default%20%3E%20(param)%20input%20%3E%20(schema)>)

sql: str

The SQL transformer query. Maximum 32 KB. The query must contain a FROM clause referencing a valid logpush dataset.

maxLength32768

[Link to this property](<#(resource)%20logpush.transformers%20%3E%20(method)%20preview%20%3E%20(params)%20default%20%3E%20(param)%20sql%20%3E%20(schema)>)

##### ReturnsExpand Collapse

Dict\[str, object]

[Link to this property](<#(resource)%20logpush.transformers%20%3E%20(model)%20transformer_preview_response%20%3E%20(schema)>)

### Preview transformer

Python

HTTPTypeScriptPythonGoTerraform

```
import os
from cloudflare import Cloudflare

client = Cloudflare(
    api_token=os.environ.get("CLOUDFLARE_API_TOKEN"),  # This is the default and can be omitted
)
page = client.logpush.transformers.preview(
    account_id="023e105f4ecef8ad9ca31a8372d0c353",
    input={
        "ClientIP": "bar",
        "ClientRequestHost": "bar",
        "EdgeStartTimestamp": "bar",
        "RayID": "bar",
    },
    sql="SELECT ClientIP, RayID FROM http_requests",
)
page = page.result[0]
print(page)
```

200 example

```
{
  "errors": [
    {
      "code": 1000,
      "message": "message",
      "documentation_url": "documentation_url",
      "source": {
        "pointer": "pointer"
      }
    }
  ],
  "messages": [
    {
      "code": 1000,
      "message": "message",
      "documentation_url": "documentation_url",
      "source": {
        "pointer": "pointer"
      }
    }
  ],
  "success": true,
  "result": [
    {
      "ClientIP": "bar",
      "RayID": "bar"
    }
  ]
}
```

##### Returns Examples

200 example

```
{
  "errors": [
    {
      "code": 1000,
      "message": "message",
      "documentation_url": "documentation_url",
      "source": {
        "pointer": "pointer"
      }
    }
  ],
  "messages": [
    {
      "code": 1000,
      "message": "message",
      "documentation_url": "documentation_url",
      "source": {
        "pointer": "pointer"
      }
    }
  ],
  "success": true,
  "result": [
    {
      "ClientIP": "bar",
      "RayID": "bar"
    }
  ]
}
```