PA00601
Kevin asked 5 years ago
Is it possible to populate the PA00601 (PA Employee Master) table via SmartConnect?Thanks…
Answers
Patrick Roth Staff answered 5 years ago
Kevin,
It depends on how you want to populate the table.
There is no eConnect endpoint that I can see in the eConnect SDK.
https://msdn.microsoft.com/en-us/library/ff623651.aspx
So if you do want to populate that table, SmartConnect lets you either:
1. populate the destination table directly with a direct SQL insert (ie no business logic).
2. you can create your stored procedure (adding any business logic that you want). then you could call it like another built-in eConnect node or just as a stored procudure
It depends on how you want to populate the table.
There is no eConnect endpoint that I can see in the eConnect SDK.
https://msdn.microsoft.com/en-us/library/ff623651.aspx
So if you do want to populate that table, SmartConnect lets you either:
1. populate the destination table directly with a direct SQL insert (ie no business logic).
2. you can create your stored procedure (adding any business logic that you want). then you could call it like another built-in eConnect node or just as a stored procudure