Skip to Content
avatar image
Former Member

Java API find main table record from lookup table reference


Im very new to the MDM Java API and Im trying to find a main table Record from a lookup table value. Whilst the API seems to support this I can be sure but I would like to avoid looping through the entire maintable checking the lookup table field value to get the correct maintable record.

In short:

Main table = Company

Lookup Table = Company Details which includes emailAddress

{tuple not a qualified ref)

I have an email address that resides in company details and I want to find the Main table company record using the email addy. ?

Any reference to a similar scenario on SDN or rough pseudo code would be really helpful..

Can I use the field ID of a tuple field in a FieldSearchDimension to find the record that I want in the main table ?

Thanks in advance.

Edited by: Richard McArthur on May 28, 2010 8:52 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 05, 2010 at 12:31 AM

    Exposing the MDM API via web services in the web service gernerator proved to be a far easier way to access the data...

    Add comment
    10|10000 characters needed characters exceeded