Object list to sheet rows

const options = {
  method: 'POST',
  headers: {'content-type': 'application/json', authorization: 'Bearer <TOKEN>'},
  body: JSON.stringify({
    config: {environment: 'production'},
    pipes: [
      {
        pipe_id: 'sheet:row:expandappend@1',
        connector: {strategy: 'first', connections: [{type: 'vault', connection: 'pipe0_123'}]},
        config: {sheet: 'sheet_id', run: true, allow_field_creation: true}
      }
    ],
    input: [{id: '1', email: 'test@pipe0.com', name: 'John Dorr'}]
  })
};

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

import requests

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

payload = {
    "config": { "environment": "production" },
    "pipes": [
        {
            "pipe_id": "sheet:row:expandappend@1",
            "connector": {
                "strategy": "first",
                "connections": [
                    {
                        "type": "vault",
                        "connection": "pipe0_123"
                    }
                ]
            },
            "config": {
                "sheet": "sheet_id",
                "run": True,
                "allow_field_creation": True
            }
        }
    ],
    "input": [
        {
            "id": "1",
            "email": "test@pipe0.com",
            "name": "John Dorr"
        }
    ]
}
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/pipes/run \
     --header 'authorization: Bearer <TOKEN>' \
     --header 'content-type: application/json' \
     --data '
{
  "config": {
    "environment": "production"
  },
  "pipes": [
    {
      "pipe_id": "sheet:row:expandappend@1",
      "connector": {
        "strategy": "first",
        "connections": [
          {
            "type": "vault",
            "connection": "pipe0_123"
          }
        ]
      },
      "config": {
        "sheet": "sheet_id",
        "run": true,
        "allow_field_creation": true
      }
    }
  ],
  "input": [
    {
      "id": "1",
      "email": "test@pipe0.com",
      "name": "John Dorr"
    }
  ]
}
'

package main

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

func main() {

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

	payload := strings.NewReader("{\"config\":{\"environment\":\"production\"},\"pipes\":[{\"pipe_id\":\"sheet:row:expandappend@1\",\"connector\":{\"strategy\":\"first\",\"connections\":[{\"type\":\"vault\",\"connection\":\"pipe0_123\"}]},\"config\":{\"sheet\":\"sheet_id\",\"run\":true,\"allow_field_creation\":true}}],\"input\":[{\"id\":\"1\",\"email\":\"test@pipe0.com\",\"name\":\"John Dorr\"}]}")

	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/pipes/run', [
  'body' => '{"config":{"environment":"production"},"pipes":[{"pipe_id":"sheet:row:expandappend@1","connector":{"strategy":"first","connections":[{"type":"vault","connection":"pipe0_123"}]},"config":{"sheet":"sheet_id","run":true,"allow_field_creation":true}}],"input":[{"id":"1","email":"test@pipe0.com","name":"John Dorr"}]}',
  'headers' => [
    'authorization' => 'Bearer <TOKEN>',
    'content-type' => 'application/json',
  ],
]);

echo $response->getBody();

POST /v1/pipes/run HTTP/1.1
Content-Type: application/json
Authorization: Bearer <TOKEN>
Host: api.pipe0.com
Content-Length: 313

{"config":{"environment":"production"},"pipes":[{"pipe_id":"sheet:row:expandappend@1","connector":{"strategy":"first","connections":[{"type":"vault","connection":"pipe0_123"}]},"config":{"sheet":"sheet_id","run":true,"allow_field_creation":true}}],"input":[{"id":"1","email":"test@pipe0.com","name":"John Dorr"}]}