Hi all,
Maybe here there is some one can help us!
Thanks to all!
Sage X3: 2020 V12 P19
Hi all,
Maybe here there is some one can help us!
Thanks to all!
Sage X3: 2020 V12 P19
Xavier,
Have you already looked at the script SPRICESEARCH_CSTD that SPRICESEARCH is using? Please see attached.
My understanding of the SPRICESEARCH is the definition of a technical class (SPRICESEARCH) containing different base properties for which the search is done (facility, product, quantity, unit, currency, price -/+ tax, reference date) and also some additional ones that are initialized from the base ones (tax rule, incoterm, payment term, delivery address, delivery mode, project etc.). The default values for these can be modified.
Are you not able to retrieve the data you need from using the ECMSOH published web services for E-commerce sales orders?
Also, one of our Ecommerce partners does this slightly different as they replicate all of the data from SPRICLIST, SPRICCONF and PRICSTRUCT and then they have written their own logic mimicking the logic of Price Search.
Hi Rafael,
Thanks for your answer.
This is my fault, I have not knowledge in class, representations, etc. I'm from the old school. I need to learn about it soon. Also in webservice SOAP have not so much experience, I wrote a TRT to use via SOAP but I has not so much experience.
ECMSOH is totally unkown for me. Really I'm completed lost :(
Gracias!
...then, How I can send for example the FAcility and the product code? into the URL. How will be the sintax?
server:8124/.../SPRICESEARCH('how I indicate here the facility and product')?representation=SPRICESEARCH.$details
Thanks!
Yes but in this case we have arround 30K products. And every day create new products. And they explote a lot the X3 tarif power, then replicate the logic is a risk and extra cost.
De nada! Have you already explored our dev site? https://developer.sage.com/api/x3/
Yes I couldn't see nothing.
I am interested in the same information, can someone help me?
Hello,
I managed to execute it with this (POST method):
<server>:8124/api1/x3/erp/<endpoint NAME>/SPRICESEARCH('')/$services/PRICESEARCH?representation=SPRICESEARCH.$edit
Body (edit the values for your context, SAUREF -> Sales unit):
{
"SALFCY": "<SALFCY - mandatory>",
"STOFCY": "<STOFCY - mandatory>",
"BPCORD": "<Customer - mandatory>",
"ITMREF": "<Product - mandatory>",
"QTYREF": 1,
"SAUREF":"PCS",
"PRITYP": 1,
"DATEREF": "2020-11-13",
"VACBPR":"",
"BPAADD":"",
"VACBPR":""
}
What you actually want to do is execute the method, hence you have to call the "service".
You can check the available methods/links in the $prototypes:
<server>:8124/api1/x3/erp/<folder>/$prototypes('SPRICESEARCH.$edit') -> I found the /$services/PRICESEARCH here
EDIT: I used V11. Did some tests with Juliano in V12 with no sucess though...
Regards,
Roberto Nascimento
Thank you Roberto!!!!
*Community Hub is the new name for Sage City