Handling Special Characters

[Mitchel_Laman]

I am reading records from the Paycor API. I have some Departments and Employee Names that have special characters. They are coming over as encoded characters.

For examples:

I have an employee with the last name of O'Brien, but it is mapping as O'Brien.

I have a department named SG&A-RevCycle, but it is mapping as SG&A-RevCycle.

I have tried using the triple brackets, but that did not change the output. Any thoughts? Grok AI suggested decodeURIComponent, but I think that is an AI hallucination.

[tylerlamparter]

When you get the data from Paycor, is it already in the encoded version or it looks normal until it gets to where you need it?

[Mitchel_Laman]

Morning, Tyler, thanks for jumping in...

The data from the Paycor manager lookup looks as follows:

{
  "page_of_records": [
    {
      "record": {
        "firstName": "Peter",
        "middleName": null,
        "lastName": "O'Grady",

The handlebar statement reads as follows (after results mapping to mgrDetails):

{{{record.mgrDetails.firstName}}} {{{record.mgrDetails.lastName}}}

It is importing into the Excel sheet as follows:

Peter O'Grady

The strange thing, it looks correct in the handlebar editor (i.e. "Peter O'Grady"). As if something is happening on it's way to Excel?

Thanks for your time and let me know if you need additional information or I can jump into Office Hours.

-mitchel

[tylerlamparter]

Are you using the Excel template from the marketplace or did you make your own import? If your own, can you share what the setup looks like?

[Mitchel_Laman]

We used the Excel template from the marketplace. The export is titled "Append new rows in bulk" and has the preMapBulk (Excel Online Helper Functions) the postMap (Excel Online Helper Functions).

[tylerlamparter]

I just updated the template in the marketplace to fix this. If you don't want to do a fresh install, you can fix this by changing primaryInterface = false in the script, then going into the HTTP body of the import and changing {{this}} to {{{this}}}.