Skip to Content
avatar image
Former Member

Java API find main table record from lookup table reference

Hi,

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