Hi everyone,
has anyone here worked with Coupa’s APIs — especially the requisition_revision_records and requisition_revision_record$requisition-lines APIs?
Does anyone know if these are still supported by Coupa?
Many thanks.
Question
Coupa api
+3Yeah
If you are using the standard Celonis Coupa Extractor, they actually pushed an update for this a while back because the primary keys for those exact revision tables were mapped wrong by default.
Pro-tip: If u are pulling requisition_revision_records and the child requisition_lines table, make sure u are joining them on revision-record_id and not just id[1]. The old extractor config used to use id which completely broke the parent/child joins for revisions[1]. Also, your delta loads will probably fail if u still have the old primary key setup on those tables[1].
[1] here January 2024 Release Notes [ old but may help maybe ]
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.