Hi, One of my table column names has a double dot in it and that column name is not getting completely converted to JSON. I noticed that JSON build truncated my column name at the first occurrence of dot. Is there a way to fix this? Thanks in advance. JSON build input table: RecordIDname.familyNamename.givenNameurn:ietf:params:scim:schemas:extension:pbx:1.0:User.pbxPhoneExtNumberuserName1UAT1User1445005uat1.user1@domain.com2 3 …and more… JSON output: { "name":{ "givenName":"UAT1", "familyName":"User1" }, "urn:ietf:params:scim:schemas:extension:pbx:1":[ { "pbxPhoneExtNumber":"445005" } ], "userName":"user1.uat1@domain.com" } How can I change this, "urn:ietf:params:scim:schemas:extension:pbx:1" To this (correct wanted output), "urn:ietf:params:scim:schemas:extension:pbx:1.0:User"

JSON build tool double dot on column name

Alc2020

Hi,

One of my table column names has a double dot in it and that column name is not getting completely converted to JSON. I noticed that JSON build truncated my column name at the first occurrence of dot. Is there a way to fix this?

Thanks in advance.

JSON build input table:

RecordID	name.familyName	name.givenName	urn:ietf:params:scim:schemas:extension:pbx:1.0:User.pbxPhoneExtNumber	userName
1	UAT1	User1	445005	uat1.user1@domain.com
2
3
	…and more…

JSON output:

{
   "name":{
      "givenName":"UAT1",
      "familyName":"User1"
   },
   "urn:ietf:params:scim:schemas:extension:pbx:1":[
      {
         "pbxPhoneExtNumber":"445005"
      }
   ],
   "userName":"user1.uat1@domain.com"
}

How can I change this,

"urn:ietf:params:scim:schemas:extension:pbx:1"

To this (correct wanted output),

"urn:ietf:params:scim:schemas:extension:pbx:1.0:User"

API

Accepted answers

Jean-Balteryx

Here is the solution I came up with, using replace before ('.' to '/') and after ('/' to '.') the JSON build.

JSON_dots.yxmd

All comments

Jean-Balteryx

Hi @Alc2020 ,

Do you have the possibility to share your JSON file ?

Alc2020

Hi @Jean-Balteryx

Here is the JSON build output:

{"name":{"familyName":"User1","givenName":"UAT1"},"urn:ietf:params:scim:schemas:extension:pbx:1":[{"pbxPhoneExtNumber":"445005"}],"userName":"user1.uat1@domain.com"}

Wanted JSON request (plus text highlighted in in blue .0:User )

{"name":{"familyName":"User1","givenName":"UAT1"},"urn:ietf:params:scim:schemas:extension:pbx:1.0:User":[{"pbxPhoneExtNumber":"445005"}],"userName":"user1.uat1@domain.com"}

Thanks,

alc

Jean-Balteryx

And what's the input ?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703