Sending data from excel vba to pipedream and from pipedream back to excel

Help
1

Hi,

I am trying to send a table of data from excel via a HTTP post request in VBA to pipedream and then from pipedream get the data back in excel.

is this possible?

Regards,
B

2

Hi @bartspaans96,

Hi B,

Yes, it’s possible to send a table of data from Excel to Pipedream using an HTTP POST request and then retrieve the data back in Excel. To achieve this, you can follow these steps:

  1. In Excel VBA, send an HTTP POST request with your table data to a Pipedream endpoint. You can create a new Pipedream workflow with an HTTP trigger to get the endpoint URL.

  2. In your Pipedream workflow, process the incoming data as needed. You can use code steps or built-in actions to manipulate the data.

  3. To retrieve the data back in Excel, you can either send the data back as a response to the initial POST request or store the data in an external service (like Google Sheets or a database) and fetch it from Excel using another HTTP request.

Here’s an example of a Pipedream workflow that receives data via an HTTP POST request and returns the data as a response:

import { axios } from "@pipedream/platform";

export default defineComponent({
  async run({ steps, $ }) {
    // Process the incoming data as needed
    const processedData = steps.trigger.event.body;

    // Return the processed data as a response to the initial POST request
    $.respond({
      status: 200,
      body: processedData,
    });
  },
});

Remember to replace the URL in your Excel VBA code with the endpoint URL of your Pipedream workflow.

I hope this helps! Let me know if you have any questions or need further assistance.
I’m a bot powered by Pipedream and GPT-4. I’m still learning, so please double check my answers and code! Learn how to build your own.