Brian Howard
It is simply not possible for us to offer support for connecting OASIS and other data systems. At least not as standard support. There are too many tools and implementation ideas.
This is where we need your help!
Post if you do have questions about how to make the JSON calls and we will reply.
Also - ask others for ideas! We are not likely to get involved, but others might have already solved connecting "super application A" to OASIS using JSON!
1
Comments
Please sign in to leave a comment.
Looking for a JSON call to give me a quote listing by Original Bid Date, Quote Status and Workgroup. I know that BidDate works, but OriginalBidDate or Original%20Bid%20Date do not. I haven't weighed into Quote Status or Workgroup yet, what would a call for these look like?
Our guru is out on vacation this week - but looks like I can answer these ...
Looks like you found a bug because OriginalBidDate was not working. (We support 3 database vendors and 2 versions of OASIS. Looks like we missed a test suite on one combination for this feature. 90% of the time - it doesn't matter, but did this time.) Update should go out by Wednesday AM.
Here is an example using all three ...
http://localhost:8080/OASIS/API?ajax=QuoteListing&Listing=Project&OriginalBidDate=LastYear:Today&Workgroup=TRTY&QuoteStatus=1,2,3
Clint,
For WorkGroup, use <CreateTerritory> in the call, rather than WorkGroup when calling against the QuoteListing table. QuoteStatus will simply be <Status>. In Brian's example above, it would be:
https://<SERVERPATH>/API?ajax=QuoteListing&Listing=Project&OriginalBidDate=<TIMEFRAME>&<CREATETERRITORY>=<CREATE TERRITORY YOU ARE SEARCHING FOR>&<STATUS>=<STATUS YOU ARE LOOKING FOR>&<AUTHENTICATION>
This would return a specific result, or range of results. If you are looking to list all Quotes in a specific time range, say this month, use:
https://<SERVERPATH>/API?ajax=QuoteListing&OriginalBidDate=<TIMEFRAME FROM>:<TIMEFRAME TO>&Listing=Project,CreateTerritory,Status&<AUTHENTICATION>
Hope that helps,
James