We are working on replacing APM with DocStar. One challenge we have is replacing logic from a homebrew web application that locates AR invoice PDF files that were sent to customers. To retrieve the file, we currently query tables in the APM database to locate the static copy of the invoice. This is fairly straightforward because both the invoice number and a pointer to the file’s location are clearly stored in the database tables.
We were told that we would be able to query the DocStar database similarly to find this information as it is attached in there as well. However, after looking at the SQL tables, it appears a bit more cumbersome.
- I cannot easily locate the key field (in this case invoice number) in the DocStar databases.
- If I start with Epicor to find the document from the invoice attachment, there is not a clear path to the content (ie, Document.Path + “/1_0_0/” + ContentItem.Filename).
Has anyone done this before or have suggestions on the best way to grab the file? Ideally, I could bypass Epicor and DocStar interfaces to retrieve the file as efficiently as possible by using a SQL query.