JSON build tool double dot on column name
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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"
Solved! Go to Solution.
- Labels:
- API
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
And what's the input ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Jean-Balteryx please see table above. That's the input to the JSON build tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you ! My bad, didn't get it !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Jean-Balteryx Thank you very much!
Although not the exact solution but his has lead me to the solution. I used replace "1.0" with "_" instead of "." so that it will not impact other column names (like name.familyName and other column names).
Regards,
Alc
