Forum Discussion

adityamohanty's avatar
adityamohanty
New Contributor II
3 years ago
Solved

How to rename a column in a single expression without impacting the other columns in a json file

My source data looks like this. I want to rename "Emp.Type" column to "EmpType" in a single expression without impacting the other columns in json file. I don't want to use column map in mapper where...
  • alchemiz's avatar
    alchemiz
    3 years ago

    Hi adityamohanty ,

    Good day, you can use mapKeys or string manipulation

    ** only top level keyname will be updated
    $.mapKeys((val,key)=> key == 'Emp.Type' ? 'EmpType' : key)


    ** global, replace all matching Emp.Type string to EmpType
    JSON.parse(JSON.stringify($).replace(/Emp.Type/gm, m => match m {'Emp.Type'=> 'EmpType'}))

    ~EmEm

Alwani's avatar
Alwani
New Contributor II
3 years ago
Copy LinkReport

Just to update you that space-delimitated does not work so checking on this how I can specify 2 scopes

ddellsperger's avatar
ddellsperger
Admin
3 years ago
Copy LinkReport

from my understanding of coupa, it needs to be specified on both sides, and from the snaplogic side, you’ll need to re-authorize when you make a change (if you just refresh, it won’t necessarily apply the update in scope). the coupa documentation states to space-delimit them (see screenshot below)
Here’s the link to their documentation for it - OAuth 2.0 Transition Guide | Coupa Unfortunately, I don’t see any specific endpoint configurations in their api documentation regarding the specific format expected, but I would suspect space separated is correct.

  • vyasyash's avatar
    vyasyash
    New Contributor III
    8 years ago
    Copy LinkReport

    Thanks for your response Prakash, is SL support still working on it. So far we were under the assumption that either there is some issue at SAP end or we’re not mapping it correctly in SnapLogic.