I have a script I managed to put together - what this does is pulls Affiliate data, matches it with the Customer, Order total and Order date - the issue is that even now the API is pretty slow and my concern over the long term as this grows is the time it will take to search all the records. Given we will end up with thousands of orders and possibly dozens of distributors, I see where this could be a long term issue......
So what I am thinking is trying to figure out or FIND OUT if it is possible to call to the API and only show the 10 most recent orders??
This would be adequate I think for the distributors and would lessen system load going forward as well... The issue I see is the way the API is limited to only date, orderID or entity... I might also add as a wishlist item to the devs - please add an API to the affiliate program if possible in future releases, as well an API that cross references name, orders, etc in one API.. right now im pulling the data from 2 seperate operations but I could see where it would be much easier if the data was available just a tad bit different :-)
And 2nd item - IS there a way to do this LOCALLY on the BC server without parsing out using PHP or .Net off server? and if NOT, what is the best "recommended" method for pulling this data BACK into BC into a secured area so when USER A logs into - USER A only sees HER orders... right now my test above is hardcoding the "distributors name" into it for lack of being sure of another way to do it and return the data to BC, e.g. via webapp or secured page....
Thanks in advance, Hope this makes sense what I am asking,
I really need some help with this - I also have ran into another issue outputting.
If there a way to get the CUSTOMER NAME - NOT ID from an order in the API - Right now im listing the customers via a custom field, but what i am finding is if customers order more than once it jacks up the output - it would be SOOOO Much easier if I could get the customers name via an order via the API not just the ID - or some way to tie to the ID to the NAME without using multiple operations.
Hey Tom - I am afraid at the moment the OrderList_Retrieve only returns the ID for the CRM ID, to get any properties for the customer that made the purchase you will need to run extract this ID and run a second call.