Data Definition Drop-Down Menu populated by external data source

James's Avatar

James

13 Jan, 2011 03:08 PM

I have a Data Definition that uses a drop-down menu. Right now, I have to hard-code the option values for the drop-down menu. I am interested in reading from an external data source, such as an XML file, to populate the option values in the drop-down. Is that possible?

  1. Support Staff 1 Posted by Tim on 13 Jan, 2011 03:15 PM

    Tim's Avatar

    Hi James,

    The only way to accomplish this would be by writing a Web Services script which would connect to your external data source, grab the values you need, then populate the data definition with those values.

    More information on Web Services can be found here.

    Let me know if you have further questions.

    Thanks

  2. 2 Posted by Jamie johnson on 13 Jan, 2011 03:23 PM

    Jamie johnson's Avatar

    Do you have an example of this type of implementation?

  3. Support Staff 3 Posted by Tim on 13 Jan, 2011 04:38 PM

    Tim's Avatar

    Here is a sample PHP script I just wrote which shows how you can edit an existing Data Definition. You'll see that I'm simply updating the Data Definition with a new XML configuration. In your case, you would want to get the values from your external data source first, then create the XML configuration using those values. Once the XML portion has been defined, you can send it in the SOAP request to update the Data Definition.

    Let me know if this makes sense.

  4. 4 Posted by Jamie johnson on 13 Jan, 2011 05:58 PM

    Jamie johnson's Avatar

    Thanks Tim,

    I don't think I will go that route. I may have found an internal means
    of doing the same thing without using a Data Definition. I will,
    however, be looking at your code to learn from your implementation.

  5. Support Staff 5 Posted by Tim on 13 Jan, 2011 05:59 PM

    Tim's Avatar

    Ok, sounds good James. Thanks for the update!

  6. Tim closed this discussion on 13 Jan, 2011 05:59 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac