Skip to main content
Documentation
Feature Requests Trust Center Status Page

Community

Connector Improvement: Coupa Connector - Rejection Data Needed in Easy Form Response Table

Answered
Vanshika Bhati User
  • Edited

We have request where we need "The last rejected at/ Rejected?" fields from the Supplier information form responses page in Coupa and it needs to be made available in Coupa Fivetran Connector so that team can work on ingesting further.

It is not currently available in the easy_form_data table of Coupa Fivetran Connector.

It will be great if we can have rejection data available in the easy_form_data table. It is highly important for end to end data analysis.

For any questions, Please feel free to let me know.

Thanks,

Vanshika

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Shivaprasad Mogili Fivetranner
    • Edited

    Hi Vanshika,

    After reviewing the API documents, I believe this information is already provided in the EASY_FORM_WIDGET_DATA table in our connector. You can view how this table is connector in our ERD. 

    If you look at easy form widget responses API endpoint from Coupa, the responses are structured as shown below. You would need to look for a row with the field-name same as the field name you are looking for. 

    "easy-form-widget-responses": [
    {
      "id": 13584,
      "field-name": "lookup_1",
      "answer": "San Francisco"
    },
{
      "id": 13585,
      "field-name": "child_easy_form_widget_2",
      "answer": {
        "child-easy-form-responses": [
          {
    ....


    If you are still unable to find this information, please reply here. 

  • Erin Fivetranner

    Hi Vanshika - 

    Thanks for submitting this feature request. I don't currently see a "rejected_at" field in the Coupa API for Easy Form data. Do you know if this is a custom field you've added to your Easy Form template, or is this a field that isn't shown in the API documentation? Any assistance you can provide will help us greatly. 

    Best,

    Erin

  • Vanshika Bhati User

    Hi Eric,

    Please refer the attached screenshot. This screenshot is from the Coupa Supplier Form where “The last rejected at/ Rejected?” Fields can be seen.

    Currently, we are using Coupa Fivetran Connector and we assume that “The last rejected at/ Rejected?” information should be available in easy_form tables as below-

    If not, could you please confirm the data availability/best possible way to fetch this information via Fivetran connector as we would like to fetch this information in the underlying snowflake tables asap.

    Thanks & Regards

    Vanshika Bhati