Connector Improvement: Workday Financial Management Supplier Invoice Line API Response Payload Empty
Answered
Based on conversations related to Case #257020, the current API for Supplier Invoice Line is not broad enough in scope to accommodate the Line detail associated with all Supplier Invoices, and for our account, is currently returning an empty response payload. The View Supplier Invoice report in Workday has and Invoice Lines section that should be repeatable from a Fivetran replication perspective. We collectively just need to work out how to move that data into the Supplier Invoice Line destination table.
-
Official comment
Hi Brad,
I'm closing this request as we were able to fix the supplier_invoice_line table and it should be populating correctly now.
Best,
Frank -
Nothing is resolved. The guidance in your schema is invalid. The following query returns no results. I assume you are just asking us to defer to the newly announced Workday Data Cloud to cover gaps in the Fivetran solution.
SELECT PURCHASE_ORDER_LINE_ID
FROM WORKDAY.FINS.SUPPLIER_INVOICE_LINE
INTERSECT
SELECT ID
FROM WORKDAY.FINS.PURCHASE_ORDER_LINE_SPLIT
-
Hi Brad,
I understand your frustration with the situation. We will work with Workday to see if we can find a resolution.
Frank
-
Has this ticket been reopened as of Nov 4th?
Please sign in to leave a comment.
Comments
4 comments