Confiform - Webservice Dropdown, How to set up?

[Munyiva Ngea]

I have created a webservice dropdown that is supposed to display the projectID from the json data:

{"draw":null,"recordsTotal":616,"recordsFiltered":616,"data":[{"projectID":"00011","ProjectIdentification":null,"umojaID":null,"ProjTitle":"(RA50100701) - UNEP Delivering as One","ProjStatus":"Closed","StartDate":"2007-06-30","EndDate":"2007-12-30","ActualStartDate":"2007-07-31","CompletionDate":null,"RevisedCompDate":"2009-01-21","TypeOfProject":"NON PRC Approved Project","ManagingDivision":"Regional Cooperation (DRC)","managing_division_id":"15","ManagingDivisionAbbr":"Regional Cooperation","ApprovedBudget":"0","Expenses":"23108.39","ManagingDivisionAbbrOld":"DRC","project_manager":"BobKakuyo [] ","principal_project_manager":null,"project_staff":"VengeNyirongo","bienium":"2010\/11","sp_number":"4","subprogramme":"Environmental governance "}

The form is

<ac:structured-macro ac:macro-id="9443c718-1900-465d-8324-894928aa0c6f" ac:name="confiform" ac:schema-version="1">
  <ac:parameter ac:name="formName">f14</ac:parameter>
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="cfc3c105-b00f-44cc-b673-44c0df35d597" ac:name="confiform-entry-register" ac:schema-version="1">
      <ac:parameter ac:name="embedded">true</ac:parameter>
      <ac:rich-text-body>
        <p>
          <br/>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p>
      <ac:structured-macro ac:macro-id="f993a406-5894-4709-b1e7-eb5acb6b4cf7" ac:name="confiform-field-definition" ac:schema-version="1">
        <ac:parameter ac:name="mapping">data|projectID|undefined</ac:parameter>
        <ac:parameter ac:name="fieldName">dd</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Dynamic dropdown</ac:parameter>
        <ac:parameter ac:name="values">modules/main/project/</ac:parameter>
        <ac:parameter ac:name="extras">89c6757001f5ca78f0a0c1e6187599a1</ac:parameter>
        <ac:parameter ac:name="type">wsselect</ac:parameter>
      </ac:structured-macro>
    </p>
  </ac:rich-text-body>

 I am getting the following error

java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
	at com.vertuna.confluence.plugins.confiforms.service.MapEntryConverter.marshal(MapEntryConverter.java:26)
	at com.thoughtworks.xstream.core.TreeMarshaller.convert(TreeMarshaller.java:70)
	at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:58)
	at com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.marshallField(AbstractReflectionConverter.java:274)
	at com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter$2.writeField(AbstractReflectio

[Alex Medved _ConfiForms_]

@Munyiva Ngea

You are missing the "Field to use as a label" in your field definition mapping

 <ac:parameter ac:name="mapping">data|projectID|undefined</ac:parameter>

[munyiva ngea]

This had to do with the version of Confiform and Confluence, I have completed the setup now.

[Ian Magero]

Do you want to set the projectID as key or value?