WIP: SAP PO Assistant, a Workato Genie on live SAP data
We've connected Workato to an SAP S/4HANA sandbox and put a Genie on top so anyone can ask about purchase orders in plain English.
The connection
- Workato HTTP connector → SAP S/4HANA OData APIs
- API key auth against the SAP sandbox
- 3 PO skills: purchase orders, PO lines, goods receipts
The outcome so far
The *SAP PO Assistant* Genie answers questions like:
- "What's the status of this PO?"
- "Has this order been received?"
- "Does this invoice match its PO?"
It pulls the answer straight from SAP. No SAP GUI, no transaction codes, no waiting on someone to run a report.
What we've learned
- Test the OData URL on its own first ($filter, $expand), then build the recipe step around it
- Keep the matching logic in a Python step; it's much easier to read and change than chained formulas
- Save a few real SAP documents as a regression set and re-run them after every change
Next: moving from sandbox to a real S/4 connection (OAuth 2.0, read-only user).
Looking for feedback on: has anyone moved a Genie from an SAP sandbox to production S/4? Did you stay on the HTTP connector or switch to the SAP OData connector?
