Pentaho

 View Only
  • 1.  Special characters API > JSON issue

    Posted 03-06-2024 06:15

    Hello,

    Currently we are using Pentaho for syncing data between Salesforce and our ERP. 

    When retreiving the characters from Salesforce, we do receive the string including all special characters like an é or ü but we receive an error from the API of our ERP.

    After monitoring the data sent to the ERP by capturing the data with Wireshark it seems all these characters are changed to "..". This results in a failure on the ERP side.

    Example;

    Boulevard Léopold is changed to Boulevard L..opold

    Is there any way to solve solve this?

    Capture from wireshark:



    ------------------------------
    Jaap Hiemstra
    Others
    Jaap Solutions
    ------------------------------


  • 2.  RE: Special characters API > JSON issue

    Posted 03-07-2024 09:04

    It is not really converting to ".." literally.  It just means that those are non-displaying characters.  You have to convert the binary values to hexadecimal to see what the ascii representation of the hexidecimal is.
    In your screenshot the two periods are :

    Hex:c3 decimal 195 Ascii Text value: Latin capital letter A with tilde Ã
    Hex: A9 decimal 169 Ascii Text Value:  Copyright sign ©

    you also have to make sure the interface is using the right encoding as well (UTF-8, ANSI, ASCII, etc..)



    ------------------------------
    Bob
    ------------------------------