Import a CSV

CSV_B64=$(base64 -w0 activities.csv)
curl -X POST https://api.dangofish.com/api.v1.Service/ImportCSV \
  -H "Authorization: Bearer $DANGO_API_KEY" \
  -H "Content-Type: application/json" \
  -d "{\"name\": \"Q3 procurement\", \"csv\": \"$CSV_B64\", \"categoryMode\": \"ademe\"}"

import base64
import os
import requests

with open("activities.csv", "rb") as f:
    csv_b64 = base64.b64encode(f.read()).decode("ascii")

resp = requests.post(
    "https://api.dangofish.com/api.v1.Service/ImportCSV",
    headers={
        "Authorization": f"Bearer {os.environ['DANGO_API_KEY']}",
        "Content-Type": "application/json",
    },
    json={"name": "Q3 procurement", "csv": csv_b64, "categoryMode": "ademe"},
)
resp.raise_for_status()
print(resp.json()["projectId"])

import { readFile } from "node:fs/promises";

const csvB64 = (await readFile("activities.csv")).toString("base64");

const resp = await fetch(
  "https://api.dangofish.com/api.v1.Service/ImportCSV",
  {
    method: "POST",
    headers: {
      Authorization: `Bearer ${process.env.DANGO_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({
      name: "Q3 procurement",
      csv: csvB64,
      categoryMode: "ademe",
    }),
  },
);
if (!resp.ok) throw new Error(`ImportCSV failed: ${resp.status}`);
const { projectId } = (await resp.json()) as { projectId: string };
console.log(projectId);

package main

import (
	"bytes"
	"encoding/base64"
	"encoding/json"
	"fmt"
	"net/http"
	"os"
)

func main() {
	raw, err := os.ReadFile("activities.csv")
	if err != nil {
		panic(err)
	}
	body, _ := json.Marshal(map[string]string{
		"name":         "Q3 procurement",
		"csv":          base64.StdEncoding.EncodeToString(raw),
		"categoryMode": "ademe",
	})

	req, _ := http.NewRequest("POST",
		"https://api.dangofish.com/api.v1.Service/ImportCSV",
		bytes.NewReader(body))
	req.Header.Set("Authorization", "Bearer "+os.Getenv("DANGO_API_KEY"))
	req.Header.Set("Content-Type", "application/json")

	resp, err := http.DefaultClient.Do(req)
	if err != nil {
		panic(err)
	}
	defer resp.Body.Close()

	var out struct {
		ProjectID string `json:"projectId"`
	}
	json.NewDecoder(resp.Body).Decode(&out)
	fmt.Println(out.ProjectID)
}