Coupa connector, add new columns
Connector name: erd (coupa)
Table name: QUOTE_REQUEST
Column to add: Public Event
Available: YES
API endpoint: GET - https://cemex.coupahost.com/api/quote_requests/{:id}
API technical path: quote-request/public
Column to add: Event Currency
Available: YES
API endpoint: GET - https://cemex.coupahost.com/api/quote_requests/{:id}
API technical path: quote-requests/currency/code
Column to add: Tags
Available: YES
API endpoint: GET - https://cemex.coupahost.com/api/quote_requests/{:id}
API technical path: quote-requests/tags
Column to add: Planned Savings
Available: YES
API endpoint: GET - https://cemex.coupahost.com/api/quote_requests/{:id}
API technical path: quote-requests/planned-savings
Additionally, the associated currency will be under: quote-requests/planned-savings-currency/code
Column to add: Negotiated Savings
Available: YES
API endpoint: GET - https://cemex.coupahost.com/api/quote_requests/{:id}
API technical path: quote-requests/negotiated-savings
Additionally, the associated currency will be under: quote-requests/negotiated-savings-currency/code
Column to add: Participation
Available: YES
API endpoint: GET - https://cemex.coupahost.com/api/quote_requests/{:id}
API technical path: quote-requests/quote-suppliers/quote-supplier/participation
Column to add: Followed from Event ID
Available: YES (confirm satisfaction)
API endpoint: GET - https://cemex.coupahost.com/api/quote_requests/{:id}
API technical path: quote-requests/original-id
Column to add: Create at
Available: YES
API endpoint: GET - https://cemex.coupahost.com/api/quote_requests/{:id}
API technical path: quote-request/create-at
Column to add: state
Available: YES
API endpoint: GET - https://cemex.coupahost.com/api/quote_requests/{:id}
API technical path: quote-requests/state
Column to add: Original id
Available: YES
API endpoint: GET - https://cemex.coupahost.com/api/quote_requests/{:id}
API technical path: quote-requests/original-id
Table name: CONTRACT
Column to add:
Available: YES
Business Object: contracts
API endpoint: GET - https://cemex.coupahost.com/api/contracts/{:id}/contract_rounds
API technical path for relevant information discussed lately:
reviews
Path to the array with nested data within each element: /contract_rounds/reviews
counterparty_reviews
Path to the array with nested data within each element: /contract_rounds/counterparty_reviews
Additional details: Coupa's current APIs return the new columns; however, these columns do not appear in the Fivetran connector and cannot be selected.
Please sign in to leave a comment.
Comments
0 comments