const equals = require("equals");
const axios = require("axios");

const API_URL = "https://api.typeform.com/forms";
const API_KEY = equals.getSecret("typeform_api_key");
const FORM_ID = equals.getSecret("typeform_form_id");

const getFormData = async () => {
  const resp = await axios({
    method: "get",
    url: `${API_URL}/${FORM_ID}/responses`,
    headers: {
      Authorization: `Bearer ${API_KEY}`,
    },
    params: {
      page_size: 96,
    },
  });

  return resp.data;
}

const formData = await getFormData();

// Create an array of column headers based on the keys of the first response
if (formData.items && formData.items.length > 0) {
  const headers = Object.keys(formData.items[0].answers);
  equals.addHeaders(headers);

  // Add a row for each response, extracting the text value from each field object
  for (const response of formData.items) {
    const rowData = Object.values(response.answers).map((field) => {
      if (field.type && (field.type === "text" || field.type === "email" || field.type === "choice" || field.type === "number" || field.type === "date")) {
        if (field.type === "text" || field.type === "number" || field.type === "date") {
          return field.text ? field.text : "";
        } else if (field.type === "email") {
          return field.email;
        } else if (field.type === "choice" && field.choices && field.choices.length > 0) {
          // The selected choice is stored in the first item of the choices array
          return field.choices[0].text;
        } else {
          return "";
        }
      }
    });
    equals.addRow(rowData);
  }
}