InfoPath Dev

 I am working on an InfoPath form (For the first time) with this form I am able to do the following

1.  I am able to do validation to against a SQL database to see if an address is in the database (if it is) I display a message " Already Exist"
2. If it does not exist -  I do a rest call -  
3. Now here is my problem
1. I was able to make the connection successfully ( Rest Call and get the Original data) in the XML form  - form the USPS API
2. I get the address with all the information.
4. Now when I go to change he Rest URL - I simply don't know what I am doing.
5. Here is what I am trying to concat and it just does not work for me.

"http://production.shippingapis.com/ShippingAPITest.dll?API=Verify&XML=<AddressValidateRequest USERID="000000MMMM " IncludeOptionalElements>true</IncludeOptionalElements><ReturnCarrierRoute>true</ReturnCarrierRoute><Address ID="0"><FirmName/> <Address1 /><Address2>205 bagwell ave</Address2><City>nutter fort </City> <State>wv</State><Urbanization></Urbanization><Zip5> </Zip5><Zip4> </Zip4></Address></AddressValidateRequest>"

I would like to Change the REST URL - but just don't think I know what I am doing so I am asking for help here.

 

Thanks for your help

CAB411

 

Error message - Invalid number of artuments - concat("http://production.shippingapis.com/ShippingAPITest.dll?API=Verify&XML=USERID='000000000000'&IncludeOptionalElements='true'&ReturnCarrierRoute='true'&$select=ID,Address2,City,State,Zip5,Zip4,DeliveryPoint,CarrierRoute,&$filter=Address2[. = AddressMy]&City[. = city]&State[. = state]&Zip5[. = zip]")

Well, you are getting an invalid number of arguments because it doesn't seem like you are actually concatenating anything together - I just see one long string. I'd guess your filter needs to be different - what in there is supposed to be fields from your form? Address2[. = AddressMy] appears to have an XPath filter on it.... Maybe attach a copy of your form under the Options tab?

 Thank you -  This is my very first InfoPath form and I really don't know what I am doing -

 

Carol 

So - what would a valid filter for your REST URL look like? What's a sample URL you can paste into a browser address bar & get data back? Mainly I'm just concerned about the filter syntax. :)

 The Result will be the

Address, city, state, and zip5 & Zip 4 code    if the address is valid  or a message with "Invalid Address" if it was not valid.

 

Thanks 

I am apparently not expressing my question well. What is a URL you can paste in a browser that will return an address? What should the filter look like? Do you have any documentation for the REST API you are trying to use?

( Note - I will send the ID Privately)

http://production.shippingapis.com/ShippingAPITest.dll?API=Verify
&XML=<AddressValidateRequest USERID="0000000000">  
<Address ID="0">
<Address1></Address1>
<Address2>6406 Ivy Lane</Address2>
<City>Greenbelt</City>
<State>MD</State>
<Zip5></Zip5>
<Zip4></Zip4>
</Address></AddressValidateRequest>

@namespace html url(http://www.w3.org/1999/xhtml); :root { font:small Verdana; font-weight: bold; padding: 2em; padding-left:4em; } * { display: block; padding-left: 2em; } html|style { display: none; } html|span, html|a { display: inline; padding: 0; font-weight: normal; text-decoration: none; } html|span.block { display: block; } *[html|hidden], span.block[html|hidden] { display: none; } .expand { display: block; } .expand:before { content: '+'; color: red; position: absolute; left: -1em; } .collapse { display: block; } .collapse:before { content: '-'; color: red; position: absolute; left:-1em; }

6406 Ivy LaneGreenbeltMD

#" class="collapse" style="color: blue; margin-left: -2em; position: relative;"><AddressValidateResponse>

6406 Ivy LaneGreenbeltMD

#" class="collapse" style="color: blue; margin-left: -2em; position: relative;"><Address ID="0"><Address2>6406 IVY LN</Address2><City>GREENBELT</City><State>MD</State><Zip5>20770</Zip5><Zip4>1441</Zip4></Address>

</AddressValidateResponse>

 

The result will be the Address2 , City, State, Zip5 and Zip 4. 

 

Thank You 

So - your webservice only takes XML? One of your posts had this: $select=ID,Address2,City,State,Zip5,Zip4,DeliveryPoint,CarrierRoute,&$filter= etc - is that also valid? If so, what would the filter syntax be?

 No it is not valid - I was just trying anything that may work and it does not work.  I did that after watching a video - but it did not help 

 

I would like to change the Address 2, City, State, Zip entered in the form. 

 

"http://production.shippingapis.com/ShippingAPITest.dll?API=Verify
&XML=<AddressValidateRequest USERID="000000000000">
<Address ID="0">
<Address1></Address1>
<Address2>6406 Ivy Lane</Address2>
<City>Greenbelt</City>
<State>MD</State>
<Zip5></Zip5>
<Zip4></Zip4>
</Address></AddressValidateRequest> "

 Yes, XML is what is accepted.

 

Thanks 

On view 1, I added a button that changes the REST URL to pass in form values. Maybe give this a try?

 Hilary,

        Thank you so much.   I am just getting a chance to look at this today and I cannot say how much I appreciate you reaching out to help me.

I will apply this to the form,  just as I thought, You are the best.

 

Thanks

Carol