Convert SOAP XML Object to JSON with Salesforce API on New Financial Report Released from EODHD APIs API

Pipedream makes it easy to connect APIs for Salesforce, EODHD APIs and 2,400+ other apps remarkably fast.

Trigger workflow on

New Financial Report Released from the EODHD APIs API

Next, do this

Convert SOAP XML Object to JSON with the Salesforce API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a EODHD APIs trigger and Salesforce action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Financial Report Released trigger
1. Connect your EODHD APIs account
2. Configure Polling interval
3. Select a Exchange Code
4. Select a Ticker (Exchange Symbols)
Configure the Convert SOAP XML Object to JSON action
1. Connect your Salesforce account
2. Configure infoBox
3. Configure XML Soap Object
4. Optional- Configure Extract Notifications Only
5. Optional- Configure Fail on Error
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

New Financial Report Released on EODHD APIs

Description:Emit new event when historical stock prices for a specific symbol are updated.

Version:0.0.1

Key:eodhd_apis-financial-report-released

View on GitHub

EODHD APIs Overview#

EODHD API offers comprehensive financial data, including end-of-day stocks, ETFs, and mutual fund prices, dividends, splits, and more across multiple exchanges globally. On Pipedream, you can harness this treasure trove of financial information to automate market analysis, update data stores, or trigger notifications based on stock movements or financial news.

Trigger Code#

import { DEFAULT_POLLING_SOURCE_TIMER_INTERVAL } from "@pipedream/platform";
import moment from "moment";
import eodhdApis from "../../eodhd_apis.app.mjs";

export default {
  key: "eodhd_apis-financial-report-released",
  name: "New Financial Report Released",
  description: "Emit new event when historical stock prices for a specific symbol are updated.",
  type: "source",
  version: "0.0.1",
  dedupe: "unique",
  props: {
    eodhdApis,
    db: "$.service.db",
    timer: {
      label: "Polling interval",
      description: "Pipedream will poll the EODHD API on this schedule",
      type: "$.interface.timer",
      default: {
        intervalSeconds: DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
      },
    },
    exchangeCode: {
      propDefinition: [
        eodhdApis,
        "exchangeCode",
      ],
    },
    symbolCode: {
      propDefinition: [
        eodhdApis,
        "symbolCode",
        ({ exchangeCode }) => ({
          exchangeCode,
        }),
      ],
    },
  },
  methods: {
    _getLastDate() {
      return this.db.get("lastDate") || 0;
    },
    _setLastDate(lastDate) {
      this.db.set("lastDate", lastDate);
    },
    async startEvent(maxResults) {
      const lastDate = this._getLastDate();
      const responseArray = [];
      let tempLastDate = lastDate;
      const {
        eodhdApis,
        exchangeCode,
        symbolCode,
      } = this;

      const items = eodhdApis.paginate({
        fn: eodhdApis.listFinancialNews,
        params: {
          s: `${symbolCode}.${exchangeCode}`,
          from: moment(lastDate).format("YYYY-MM-DD"),
        },
        maxResults,
      });

      for await (const item of items) {
        const newLastDate = moment(item.date);

        if (moment(newLastDate).isSameOrAfter(lastDate)) {
          if (moment(newLastDate).isAfter(tempLastDate)) {
            tempLastDate = newLastDate;
          }
          responseArray.push(item);
        } else {
          break;
        }
      }

      if (!moment(lastDate).isSame(tempLastDate))
        this._setLastDate(tempLastDate);

      for (const responseItem of responseArray.reverse()) {
        this.$emit(
          responseItem,
          {
            id: responseItem.date,
            summary: `A new report with title "${responseItem.title}" was created!`,
            ts: responseItem.date,
          },
        );
      }
    },
  },
  hooks: {
    async deploy() {
      await this.startEvent(25);
    },
  },
  async run() {
    await this.startEvent();
  },
};

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
EODHD APIs	`eodhdApis`	`app`	This component uses the EODHD APIs app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
Polling interval	`timer`	`$.interface.timer`	Pipedream will poll the EODHD API on this schedule
Exchange Code	`exchangeCode`	`string`	Select a value from the drop down menu.
Ticker (Exchange Symbols)	`symbolCode`	`string`	Select a value from the drop down menu.

Trigger Authentication#

EODHD APIs uses API keys for authentication. When you connect your EODHD APIs account, Pipedream securely stores the keys so you can easily authenticate to EODHD APIs APIs in both code and no-code steps.

About EODHD APIs#

Stock market fundamental and historical prices API for stocks, ETFs, mutual funds and bonds all over the world.

Action#

Convert SOAP XML Object to JSON on Salesforce

Description:Converts a SOAP XML Object received from Salesforce to JSON

Version:0.0.6

Key:salesforce_rest_api-convert-soap-xml-to-json

View on GitHub

Salesforce Overview#

The Salesforce (REST API) provides a powerful platform for creating and managing customer relationships with a wide array of features like data manipulation, querying, and complex automation. With Pipedream's serverless execution, you can create workflows that automate your sales processes, sync data with other platforms, enhance customer engagement, and trigger actions based on specific events. Dive into Salesforce data, streamline lead management, track customer interactions, and push or pull data to or from Salesforce seamlessly.

Action Code#

import salesforce_rest_api from "../../salesforce_rest_api.app.mjs";
import converter from "../../../helper_functions/actions/xml-to-json/xml-to-json.mjs";

export default {
  key: "salesforce_rest_api-convert-soap-xml-to-json",
  name: "Convert SOAP XML Object to JSON",
  description: "Converts a SOAP XML Object received from Salesforce to JSON",
  version: "0.0.6",
  type: "action",
  props: {
    salesforce_rest_api,
    infoBox: {
      type: "alert",
      alertType: "info",
      content: `This action is useful in conjunction with Salesforce Flow Builder, and is primarily used if Instant triggers are not working for your use case.
\\
[See the documentation](https://pipedream.com/apps/salesforce-rest-api#troubleshooting) for more details.`,
    },
    xml: {
      type: "string",
      label: "XML Soap Object",
      description: "The object received from Salesforce that will be converted.",
    },
    extractNotificationOnly: {
      type: "boolean",
      label: "Extract Notifications Only",
      description: "Whether to extract only the notification parts from the XML. Default: `true`.",
      optional: true,
      default: true,
    },
    failOnError: {
      type: "boolean",
      label: "Fail on Error",
      description: "Whether the action should fail if an error occurs when extracting notifications. Default: `false`.",
      optional: true,
      default: false,
    },
  },
  async run({ $ }) {
    const json = await converter.run.bind({
      input: this.xml,
      compact: false,
    })({
      $,
    });

    if (!this.extractNotificationOnly) {
      return json;
    }

    try {
      const notifications = json.elements[0].elements[0].elements[0].elements
        .filter(({ name }) => name === "Notification");
      $.export("$summary", "Successfully converted to JSON and extracted notifications");
      return {
        notifications,
      };
    } catch (e) {
      const errorMessage = "Successfully converted to JSON, but was unable to extract notifications";
      if (this.failOnError) {
        $.export("$summary", errorMessage); // overrides exported $summary in converter
        throw new Error(errorMessage);
      }

      $.export("$summary", `${errorMessage}. Will return the whole JSON.`);
      return json;
    }
  },
};

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
Salesforce	`salesforce_rest_api`	`app`	This component uses the Salesforce app.
XML Soap Object	`xml`	`string`	The object received from Salesforce that will be converted.
Extract Notifications Only	`extractNotificationOnly`	`boolean`	Whether to extract only the notification parts from the XML. Default: `true`.
Fail on Error	`failOnError`	`boolean`	Whether the action should fail if an error occurs when extracting notifications. Default: `false`.

Action Authentication#

Salesforce uses OAuth authentication. When you connect your Salesforce account, Pipedream will open a popup window where you can sign into Salesforce and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Salesforce API.

Pipedream requests the following authorization scopes when you connect your account:

About Salesforce#

Web services API for interacting with Salesforce

More Ways to Connect Salesforce + EODHD APIs#

Other Popular Integrations#

Search Stock Symbol with EODHD APIs API on New Object (of Selectable Type) from Salesforce (REST API) API

Salesforce + EODHD APIs

Convert SOAP XML Object to JSON with Salesforce API on New Financial Report Released from EODHD APIs API

Pipedream makes it easy to connect APIs for Salesforce, EODHD APIs and 2,400+ other apps remarkably fast.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

1-24of2,400+apps by most popular

1
-
24
of
2,400+
apps by most popular