Newbie Questions

Re: Infopath 2010

cab411 — Fri, 13 May 2016 19:26:35 GMT

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

Re: Infopath 2010

Hilary Stoupa — Thu, 12 May 2016 22:14:17 GMT

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

Re: Infopath 2010

cab411 — Thu, 12 May 2016 19:43:49 GMT

Yes, XML is what is accepted.

Thanks

Re: Infopath 2010

cab411 — Thu, 12 May 2016 19:37:24 GMT

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> "

Re: Infopath 2010

Hilary Stoupa — Thu, 12 May 2016 19:31:51 GMT

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?

Re: Infopath 2010

cab411 — Thu, 12 May 2016 19:27:53 GMT

( 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>

<?xml version="1.0" encoding="UTF-8"?>

@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

Re: Infopath 2010

Hilary Stoupa — Thu, 12 May 2016 19:13:44 GMT

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?

Re: Infopath 2010

cab411 — Thu, 12 May 2016 19:06:01 GMT

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

Re: Infopath 2010

Hilary Stoupa — Thu, 12 May 2016 18:01:28 GMT

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. :)

Re: Infopath 2010

cab411 — Thu, 12 May 2016 17:49:47 GMT

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

Carol

Re: Infopath 2010

Hilary Stoupa — Thu, 12 May 2016 15:45:18 GMT

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?

Re: Infopath 2010

cab411 — Thu, 12 May 2016 14:04:14 GMT

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]")

Infopath 2010

cab411 — Wed, 11 May 2016 16:28:49 GMT

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

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"
If it does not exist - I do a rest call -
Now here is my problem

I was able to make the connection successfully ( Rest Call and get the Original data) in the XML form - form the USPS API
I get the address with all the information.

Now when I go to change he Rest URL - I simply don't know what I am doing.
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