Forum Discussion

NSHAIK2's avatar
NSHAIK2
New Contributor
7 months ago

Dat Integration

Hello, OneStream Community

We currently have OneStream set up to load data files automatically over the filesahre API, notifying users via email when something goes wrong or succeeds.

In addition, I would want to compute the validation errors from OneStream and email them to the users about the invalid intersections.

Could someone please tell me how to go about doing that?

Regards

Data Integration
REST Api
Transformation
  • franciscoamores's avatar
    franciscoamores
    Contributor II
    7 months ago

    Hi,

    that topic has been covered in other threads but there are two methods:

    1) SQL query

    2) API

    with teh SQL query you will have to do some parsing if you want show info correctly.

    The best starting point for this is the OpenPlace app for Stage Validation Errors. YOu can the SQL query from there.