logo-darkPipe0

Read sheet rows

List rows from a pipe0 sheet.

ProviderBilling ModeCredentials
Cost per search
Docs
P
pipe0
Per Search
Managed, User

0.00 credits

Output Fields

Dynamic output fields

This search's output columns are determined at run time and depend on the data source, so they aren't known ahead of time. Enable config.field_definitions.enabled to receive the columns alongside your results in the response field_definitions.

Code Example

const options = {
  method: 'POST',
  headers: {'content-type': 'application/json', authorization: 'Bearer <TOKEN>'},
  body: JSON.stringify({
    search: {
      search_id: 'sheet:rows@1',
      connector: {strategy: 'first'},
      config: {sheet: 'demo-leads', limit: 100, cursor: '', include_metadata: false}
    }
  })
};

fetch('https://api.pipe0.com/v1/search/run', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));
import requests

url = "https://api.pipe0.com/v1/search/run"

payload = { "search": {
        "search_id": "sheet:rows@1",
        "connector": { "strategy": "first" },
        "config": {
            "sheet": "demo-leads",
            "limit": 100,
            "cursor": "",
            "include_metadata": False
        }
    } }
headers = {
    "content-type": "application/json",
    "authorization": "Bearer <TOKEN>"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)
curl --request POST \
     --url https://api.pipe0.com/v1/search/run \
     --header 'authorization: Bearer <TOKEN>' \
     --header 'content-type: application/json' \
     --data '
{
  "search": {
    "search_id": "sheet:rows@1",
    "connector": {
      "strategy": "first"
    },
    "config": {
      "sheet": "demo-leads",
      "limit": 100,
      "cursor": "",
      "include_metadata": false
    }
  }
}
'
package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://api.pipe0.com/v1/search/run"

	payload := strings.NewReader("{\"search\":{\"search_id\":\"sheet:rows@1\",\"connector\":{\"strategy\":\"first\"},\"config\":{\"sheet\":\"demo-leads\",\"limit\":100,\"cursor\":\"\",\"include_metadata\":false}}}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("content-type", "application/json")
	req.Header.Add("authorization", "Bearer <TOKEN>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}
<?php
require_once('vendor/autoload.php');

$client = new \GuzzleHttp\Client();

$response = $client->request('POST', 'https://api.pipe0.com/v1/search/run', [
  'body' => '{"search":{"search_id":"sheet:rows@1","connector":{"strategy":"first"},"config":{"sheet":"demo-leads","limit":100,"cursor":"","include_metadata":false}}}',
  'headers' => [
    'authorization' => 'Bearer <TOKEN>',
    'content-type' => 'application/json',
  ],
]);

echo $response->getBody();
POST /v1/search/run HTTP/1.1
Content-Type: application/json
Authorization: Bearer <TOKEN>
Host: api.pipe0.com
Content-Length: 153

{"search":{"search_id":"sheet:rows@1","connector":{"strategy":"first"},"config":{"sheet":"demo-leads","limit":100,"cursor":"","include_metadata":false}}}