mibuso.com
Home› NAV Three Tier

BPost SOAP Call Address Validation

bcengizbcengiz Member Posts: 8
edited 2018-07-17 in NAV Three Tier
Hi

I'm trying to connect a soap webservice api to validate addresses.
Therefore the Belgian mail delivery company BPost has a free webservice platform to use it.

In the SOAPUI , I could connect and try some requests and got some response. Unfortunately, I have some XML HTTP Status = 500 error when I try to connect in NAV C/AL.

via this website, you can find the documentation of this free webservice "https://www.bpost.be/site/en/webservice-address

Is there someone who can give me some advise? Maybe I'm looking over an connection issue?

New Codeunit Validate Addresses

OnRun()
CLEAR(AutXmlDoc);
CLEAR(AutXmlHttp);

IF ISCLEAR(AutXmlDoc) THEN
  CREATE(AutXmlDoc,FALSE,TRUE);
IF ISCLEAR(AutXmlHttp) THEN
  CREATE(AutXmlHttp,FALSE,TRUE);

AutXmlHttp.open('POST','https://webservices-pub.bpost.be/ws/ExternalMailingAddressProofingCS_v1',FALSE);
AutXmlHttp.setRequestHeader('Content-Type','text/xml; charset=utf-8');
AutXmlHttp.setRequestHeader('SOAPAction',
                            'http://schema.bpost.be/services/common/address/ExternalMailingAddressProofingCS/V001/validateAddress');
AutXmlHttp.setRequestHeader('Operation','validateAddresses');
AutXmlHttp.setRequestHeader('Style','Document');
AutXmlHttp.setRequestHeader('Endpoint','https://webservices-pub.bpost.be/ws/ExternalMailingAddressProofingCS_v1');

FillXMLDoc();

AutXmlHttp.send(AurXmlText.nodeValue);

MESSAGE(FORMAT(AutXmlHttp.status));
IF AutXmlHttp.status = 200 THEN BEGIN
  AutXmlDoc.load(AutXmlHttp.responseXML);
  AutXmlNodeList := AutXmlDoc.childNodes;
 
  FOR i := 0 TO AutXmlNodeList.length - 1 DO BEGIN
    AutXmlNode := AutXmlNodeList.item(i);
    ReadChildNodes(AutXmlNode);
  END;

FillXMLDoc()
AurXmlText := AutXmlDoc.createTextNode('');
AurXmlText.appendData('<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" ');
AurXmlText.appendData('xmlns:v001="http://schema.bpost.be/services/common/address/ExternalMailingAddressProofingCSMessages/v001">');
AurXmlText.appendData('<soapenv:Header/>');
AurXmlText.appendData('<soapenv:Body>');
AurXmlText.appendData('<v001:ValidateAddressesRequest>');
AurXmlText.appendData('<v001:AddressToValidateList>');
AurXmlText.appendData('<v001:AddressToValidate id="1">');
AurXmlText.appendData('<v001:MaileeAndAddressee>');
AurXmlText.appendData('<v001:AddresseeIndividualIdentification>');
AurXmlText.appendData('<v001:StructuredAddresseeIndividualIdentification>');
AurXmlText.appendData('</v001:StructuredAddresseeIndividualIdentification>');
AurXmlText.appendData('</v001:AddresseeIndividualIdentification>');
AurXmlText.appendData('<v001:MaileeIndividualIdentification>');
AurXmlText.appendData('<v001:StructuredMaileeIndividualIdentification>');
AurXmlText.appendData('<v001:MaileeRole></v001:MaileeRole>');
AurXmlText.appendData('</v001:StructuredMaileeIndividualIdentification>');
AurXmlText.appendData('</v001:MaileeIndividualIdentification>');
AurXmlText.appendData('<v001:MaileeOrganizationIdentification>');
AurXmlText.appendData('<v001:StructuredMaileeOrganizationIdentification>');
AurXmlText.appendData('</v001:StructuredMaileeOrganizationIdentification>');
AurXmlText.appendData('</v001:MaileeOrganizationIdentification>');
AurXmlText.appendData('<v001:MailRecipientDispatchingInformation>');
AurXmlText.appendData('<v001:StructuredMailRecipientDispatchingInformation>');
AurXmlText.appendData('<v001:Wing>');
AurXmlText.appendData('</v001:Wing>');
AurXmlText.appendData('<v001:Stairwell>');
AurXmlText.appendData('</v001:Stairwell>');
AurXmlText.appendData('<v001:Floor>');
AurXmlText.appendData('</v001:Floor>');
AurXmlText.appendData('<v001:Door>');
AurXmlText.appendData('</v001:Door>');
AurXmlText.appendData('</v001:StructuredMailRecipientDispatchingInformation>');
AurXmlText.appendData('</v001:MailRecipientDispatchingInformation>');
AurXmlText.appendData('</v001:MaileeAndAddressee>');
AurXmlText.appendData('<v001:PostalAddress>');
AurXmlText.appendData('<v001:OtherDeliveryInformation>');
AurXmlText.appendData('<v001:StructuredOtherDeliveryInformation>');
AurXmlText.appendData('</v001:StructuredOtherDeliveryInformation>');
AurXmlText.appendData('</v001:OtherDeliveryInformation>');
AurXmlText.appendData('<v001:DeliveryPointLocation>');
AurXmlText.appendData('<v001:StructuredDeliveryPointLocation>');
AurXmlText.appendData('<v001:StreetName>'+FORMAT(StreetNameG) +'</v001:StreetName>');
AurXmlText.appendData('<v001:StreetNumber>'+FORMAT(StreetNoG)+'</v001:StreetNumber>');
AurXmlText.appendData('<v001:BoxNumber></v001:BoxNumber>');
AurXmlText.appendData('</v001:StructuredDeliveryPointLocation>');
AurXmlText.appendData('</v001:DeliveryPointLocation>');
AurXmlText.appendData('<v001:PostalCodeMunicipality>');
AurXmlText.appendData('<v001:StructuredPostalCodeMunicipality>');
AurXmlText.appendData('<v001:PostalCode>'+FORMAT(PostalCodeG)+'</v001:PostalCode>');
AurXmlText.appendData('<v001:MunicipalityName>'+FORMAT(CityG)+'</v001:MunicipalityName>');
AurXmlText.appendData('</v001:StructuredPostalCodeMunicipality>');
AurXmlText.appendData('</v001:PostalCodeMunicipality>');
AurXmlText.appendData('</v001:PostalAddress>');
AurXmlText.appendData('<v001:DispatchingCountryISOCode>BE</v001:DispatchingCountryISOCode>');
AurXmlText.appendData('<v001:DeliveringCountryISOCode>BE</v001:DeliveringCountryISOCode>');
AurXmlText.appendData('</v001:AddressToValidate>');
AurXmlText.appendData('</v001:AddressToValidateList>');
AurXmlText.appendData('<v001:ValidateAddressOptions>');
AurXmlText.appendData('<v001:IncludeFormatting>true</v001:IncludeFormatting>');
AurXmlText.appendData('<v001:IncludeSuggestions>true</v001:IncludeSuggestions>');
AurXmlText.appendData('<v001:IncludeSubmittedAddress>true</v001:IncludeSubmittedAddress>');
AurXmlText.appendData('</v001:ValidateAddressOptions>');
AurXmlText.appendData('<v001:CallerIdentification>');
AurXmlText.appendData('<v001:CallerName>customername</v001:CallerName>');
AurXmlText.appendData('</v001:CallerIdentification>');
AurXmlText.appendData('</v001:ValidateAddressesRequest>');
AurXmlText.appendData('</soapenv:Body>');
AurXmlText.appendData('</soapenv:Envelope>');

ReadChildNodes()
CASE FORMAT(CurrentXMLNodeP.nodeType) OF
'1': // Element 
  BEGIN
    // Global variable CurrentElementName to keep track of what node
    // we are currently processing
    CurrentElementNameG := CurrentXMLNodeP.nodeName;

    // Process Attributes
    // If the element has attributes, then browse through those.
    TempXMLAttributeListL := CurrentXMLNodeP.attributes;
    FOR k := 0 TO TempXMLAttributeListL.length - 1 DO
      ReadChildNodes(TempXMLAttributeListL.item(k));

    // Process Child nodes
    TempXMLNodeListL := CurrentXMLNodeP.childNodes;
    FOR j := 0 TO TempXMLNodeListL.length - 1 DO
      ReadChildNodes(TempXMLNodeListL.item(j));
  END;

'2': // Attribute 
  BEGIN
    MESSAGE(CurrentElementNameG + ' Attribute : ' +
    FORMAT(CurrentXMLNodeP.nodeName) + ' = ' + FORMAT(CurrentXMLNodeP.nodeValue));
  END;

'3': // Text 
  BEGIN
    MESSAGE(CurrentElementNameG + ' Text = ' + FORMAT(CurrentXMLNodeP.nodeValue));
  END;
END;

SetAddress()
StreetNameG := StreetnameP;
StreetNoG := StreetNoP;
PostalCodeG := PostalCodeP;
CityG := CityP;


SOAPUI Settings, connections and properties.

70nfvallsu0p.jpg
9hhfjmh46pen.jpg
3cwqh9uphg8l.jpg
usvdjj6wqa7w.jpg
3pphq2aowsuq.jpg

Answers

  • bcengizbcengiz Member Posts: 8
    <Continued information>

    SOAP UI XML Request

    <!--copy paste all text below into the XML request which is send to the webservice:-->
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/&quot; xmlns:v001="http://schema.bpost.be/services/common/address/ExternalMailingAddressProofingCSMessages/v001"&gt;
    <soapenv:Header/>
    <soapenv:Body>
    <v001:ValidateAddressesRequest>
    <v001:AddressToValidateList>
    <!--1 to 100 repetitions:-->
    <v001:AddressToValidate id="1">
    <v001:MaileeAndAddressee>
    <v001:AddresseeIndividualIdentification>
    <v001:StructuredAddresseeIndividualIdentification>
    <v001:AddresseeFormOfAddress>Mr</v001:AddresseeFormOfAddress>
    <v001:AddresseeGivenName>Jean</v001:AddresseeGivenName>
    <v001:AddresseeSurname>Dupont</v001:AddresseeSurname>
    </v001:StructuredAddresseeIndividualIdentification>
    </v001:AddresseeIndividualIdentification>
    <v001:MaileeIndividualIdentification>
    <v001:StructuredMaileeIndividualIdentification>
    <v001:MaileeRole></v001:MaileeRole>
    </v001:StructuredMaileeIndividualIdentification>
    </v001:MaileeIndividualIdentification>
    <v001:MaileeOrganizationIdentification>
    <v001:StructuredMaileeOrganizationIdentification>
    </v001:StructuredMaileeOrganizationIdentification>
    </v001:MaileeOrganizationIdentification>
    <v001:MailRecipientDispatchingInformation>
    <v001:StructuredMailRecipientDispatchingInformation>
    <v001:Wing>
    </v001:Wing>
    <v001:Stairwell>
    </v001:Stairwell>
    <v001:Floor>
    </v001:Floor>
    <v001:Door>
    </v001:Door>
    </v001:StructuredMailRecipientDispatchingInformation>
    </v001:MailRecipientDispatchingInformation>
    </v001:MaileeAndAddressee>
    <v001:PostalAddress>
    <v001:OtherDeliveryInformation>
    <v001:StructuredOtherDeliveryInformation>
    </v001:StructuredOtherDeliveryInformation>
    </v001:OtherDeliveryInformation>
    <v001:DeliveryPointLocation>
    <v001:StructuredDeliveryPointLocation>
    <v001:StreetName>Avenue Brugmann</v001:StreetName>
    <v001:StreetNumber>1</v001:StreetNumber>
    <v001:BoxNumber>2</v001:BoxNumber>
    </v001:StructuredDeliveryPointLocation>
    </v001:DeliveryPointLocation>
    <v001:PostalCodeMunicipality>
    <v001:StructuredPostalCodeMunicipality>
    <v001:PostalCode>1180</v001:PostalCode>
    <v001:MunicipalityName>Uccle</v001:MunicipalityName>
    </v001:StructuredPostalCodeMunicipality>
    </v001:PostalCodeMunicipality>
    </v001:PostalAddress>
    <v001:DispatchingCountryISOCode>BE</v001:DispatchingCountryISOCode>
    <v001:DeliveringCountryISOCode>BE</v001:DeliveringCountryISOCode>
    </v001:AddressToValidate>
    </v001:AddressToValidateList>
    <v001:ValidateAddressOptions>
    <v001:IncludeFormatting>true</v001:IncludeFormatting>
    <v001:IncludeSuggestions>true</v001:IncludeSuggestions>
    <v001:IncludeSubmittedAddress>true</v001:IncludeSubmittedAddress>
    </v001:ValidateAddressOptions>
    <v001:CallerIdentification>
    <v001:CallerName>customername</v001:CallerName>
    </v001:CallerIdentification>
    </v001:ValidateAddressesRequest>
    </soapenv:Body>
    </soapenv:Envelope>


    SOAP UI XML RESPONSE
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"&gt;
    <soapenv:Body>
    <msg:ValidateAddressesResponse xmlns:msg="http://schema.bpost.be/services/common/address/ExternalMailingAddressProofingCSMessages/v001"&gt;
    <msg:ValidatedAddressResultList>
    <msg:ValidatedAddressResult id="1">
    <msg:MaileeAndAddressee>
    <msg:AddresseeIndividualIdentification>
    <msg:StructuredAddresseeIndividualIdentification>
    <msg:AddresseeFormOfAddress>Mr</msg:AddresseeFormOfAddress>
    <msg:AddresseeGivenName>Jean</msg:AddresseeGivenName>
    <msg:AddresseeSurname>Dupont</msg:AddresseeSurname>
    </msg:StructuredAddresseeIndividualIdentification>
    </msg:AddresseeIndividualIdentification>
    <msg:MaileeIndividualIdentification>
    <msg:StructuredMaileeIndividualIdentification>
    <msg:MaileeRole/>
    </msg:StructuredMaileeIndividualIdentification>
    </msg:MaileeIndividualIdentification>
    </msg:MaileeAndAddressee>
    <msg:ValidatedAddressList>
    <msg:ValidatedAddress>
    <msg:PostalAddress>
    <msg:StructuredDeliveryPointLocation>
    <msg:StreetName>AVENUE BRUGMANN</msg:StreetName>
    <msg:StreetNumber>1</msg:StreetNumber>
    </msg:StructuredDeliveryPointLocation>
    <msg:StructuredPostalCodeMunicipality>
    <msg:PostalCode>1060</msg:PostalCode>
    <msg:MunicipalityName>SAINT-GILLES</msg:MunicipalityName>
    </msg:StructuredPostalCodeMunicipality>
    <msg:CountryName>BELGIQUE</msg:CountryName>
    </msg:PostalAddress>
    <msg:AddressLanguage>fr</msg:AddressLanguage>
    <msg:Label>
    <msg:Line>Mr Jean Dupont</msg:Line>
    <msg:Line>AVENUE BRUGMANN 1</msg:Line>
    <msg:Line>1060 SAINT-GILLES</msg:Line>
    </msg:Label>
    </msg:ValidatedAddress>
    </msg:ValidatedAddressList>
    <msg:Error>
    <msg:ComponentRef>MunicipalityName</msg:ComponentRef>
    <msg:ErrorCode>anomaly_in_field</msg:ErrorCode>
    <msg:ErrorSeverity>warning</msg:ErrorSeverity>
    </msg:Error>
    <msg:Error>
    <msg:ComponentRef>PostalCode</msg:ComponentRef>
    <msg:ErrorCode>anomaly_in_field</msg:ErrorCode>
    <msg:ErrorSeverity>warning</msg:ErrorSeverity>
    </msg:Error>
    <msg:Error>
    <msg:ComponentRef>BoxNumber</msg:ComponentRef>
    <msg:ErrorCode>anomaly_in_field</msg:ErrorCode>
    <msg:ErrorSeverity>warning</msg:ErrorSeverity>
    </msg:Error>
    <msg:DetectedInputAddressLanguage>fr</msg:DetectedInputAddressLanguage>
    <msg:FormattedSubmittedAddress>
    <msg:Line>Mr Jean Dupont</msg:Line>
    <msg:Line>Avenue Brugmann 1 box 2</msg:Line>
    <msg:Line>1180 Uccle</msg:Line>
    </msg:FormattedSubmittedAddress>
    <msg:TransactionID>7a5b6e26-83fd-46de-8d7d-b0366bd58437</msg:TransactionID>
    </msg:ValidatedAddressResult>
    </msg:ValidatedAddressResultList>
    </msg:ValidateAddressesResponse>
    </soapenv:Body>
    </soapenv:Envelope>
  • HannesHolstHannesHolst Member Posts: 119
    Hi,

    When you are able to get for the same payload a response through SoapUI, then it's potentially a problem in your http-connection.

    Just a guess, did you consider TLS in your code?
    Most modern webservices discontinued SSL and did made TLS mandatory.
    My blog - https://www.HannesHolst.com/
  • krikikriki Member, Moderator Posts: 9,112
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.