Converting Airtable data into JSON for the raw code element

Hi @Troy Tessalone,

I’m trying to pass a few payloads through some custom code. But I can’t get the payload to pass through from Airtable. 

This is my code: 
 

// Define the output variable
console.log(inputData)
let output;

// Set up variables for the Webflow API endpoint and the item you want to update
const endpoint = 'https://api.webflow.com/collections/{collection_id}/items/{item_id}';
const collectionId = '63e1bdb25639fe5b8188bb75';
const itemId = 'itemIDPayload';

// Set up the data you want to send in the PATCH request
const data = {
  fields: {
    // The name of the multi-reference field you want to update
    'multi_reference_field': [
      // The IDs of the items you want to reference in the multi-reference field
      'wrappedAirtableItems'
    ],
    // Set name, archived, and draft to false
    'name': 'My New Name',
    '_archived': false,
    '_draft': false
  }
};

// Set up the headers for the Webflow API request
const headers = {
  'Content-Type': 'application/json',
  'Authorization': 'Bearer 6afb5041dadfb64aa2a34386c0ed5a7d2fdc4d5fd2c774bdc8aca9c80f005549',
  'accept-version': '1.0.0'
};

// Send the PATCH request using the Fetch API with a callback function
fetch(endpoint.replace('{collection_id}', collectionId).replace('{item_id}', itemId), {
  method: 'PATCH',
  headers: headers,
  body: JSON.stringify(data)
})
  .then(res => res.json())
  .then(json => {
    console.log(json);
    // Set the output data
    output = {
      id: json._id,
      message: 'Item updated successfully'
    };
  })
  .catch(err => console.error(err));

// Export the output variable
module.exports = {
  output: output
};

Hi @Troy Tessalone, 

The data from the input section of the Code isn’t being passed through into the Javasscript properly. So I’m wondering if I should change my approach and extract the Airtable data as JSON structured. 
 

Best,

Nicholas 

Hi @Nick Platt I can get this done for you, I watched your loom from Upwork, feel free to connect with me on there. Happy to delay payment until proof of solution.   

Regards,

Hamish