Integrate the Sinch MessageMedia API with the PostgreSQL API

import axios from "axios";
import crypto from 'crypto';

export default defineComponent({
  props: {
    sinch_messagemedia: {
      type: "app",
      app: "sinch_messagemedia",
    }
  },
  async run({ steps, $ }) {
    // Date header in RFC7231 format
    const date = new Date().toUTCString();

    // Signing string (No Content-MD5 needed as this is a GET request with no body)
    const requestLine = 'GET /v1/messaging/numbers/sender_address/addresses/ HTTP/1.1';
    const signingString = `Date: ${date}\n${requestLine}`;

    // Creating HMAC-SHA1 hash
    const hmac = crypto.createHmac('sha1', this.sinch_messagemedia.$auth.api_secret);
    hmac.update(signingString);

    // Base64 encode the hash
    const signature = hmac.digest('base64');

    // Prepare authentication header and make the request
    const authHeader = `hmac username="${this.sinch_messagemedia.$auth.api_key}", algorithm="hmac-sha1", headers="Date request-line", signature="${signature}"`;
    const response = await axios({
      method: 'get',
      url: `${this.sinch_messagemedia.$auth.api_url}/v1/messaging/numbers/sender_address/addresses/`,
      headers: {
        'Date': date,
        'Authorization': authHeader,
        'Accept': 'application/json'
      }
    });

    return response.data;
  },
})

import postgresql from "@pipedream/postgresql"

export default defineComponent({
  props: {
    postgresql,
  },
  async run({ steps, $ }) {
    // Component source code:
    // https://github.com/PipedreamHQ/pipedream/tree/master/components/postgresql

    const queryObj = {
      text: "SELECT NOW()",
      values: [], // Ignored since query does not contain placeholders
    };
    return await this.postgresql.executeQuery(queryObj);
  },
})