Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Not Answered
  • Replies replies
    5
  • Subscribers subscribers
    8
  • Views views
    1113
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to get list of customers with PCMS API

abs_dev

Hi all,

I want to get a list of existing customers with pcms-api.

I have found from the documentation, a constant called PCMS_CUSTOMER. Normally this variable is objtype that I can use it to take information about customers. However, I tried to interog the database with PCMSQUERY but since the documentation I cannot use this constant with this way of interrogation. I looked in another document that talks about using a PO line to list customers but just found how to create a customer or delete a customer or update a customer. Can someone help me on the subject please?

 

Parents
  • 0

    Hello,

    I am afraid PCMS_CUSTOMER is not supported with PcmsQuery/PcmsFullQuery.

    Perhaps the possible option is similar to Releases - querying DB through the Published Views.

    --
    Regards,
    Alex

    --
    Alex Shevchenko
    Sr Development Manager
    Although I work for OpenText, I am speaking for myself and not for OpenText.
    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button.

  • 0 in reply to 

    Hi Alex,

    Thank you about your answer.

    Can you have an example for querying DB through the Published Views please because i'm really stuck

     

Reply Children
  • 0 in reply to 

    Unfortunately I have no code example of Published View usage at hand.
    But how I'd imagine that - you will need to query your Dimensions DB either via dmdba ustility (execute and parse the output), or via ODBC driver directly from the code, or via native DBMS library (which depends on the DB type you use, say OCI for Oracle).

    --
    Alex Shevchenko
    Sr Development Manager
    Although I work for OpenText, I am speaking for myself and not for OpenText.
    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button.

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.