Legacy Dev Forum Posts

 View Only

Sign Up

Back to discussions
Expand all | Collapse all

Dot Walk/Notation issue when receiving data from Service Now

  • 1.  Dot Walk/Notation issue when receiving data from Service Now

    Posted 06-05-2025 18:43

    Egill_Palsson | 2022-03-14 14:32:38 UTC | #1

    Hi, I am trying to wrap my head around how to assign a dot-walked value returned from ServiceNow in a data Action. According to step.8 "Execute", the data is indeed returned. But I am unable to get the translation Map to catch it and assign it to a Contract.

    This is the Returned JSON: { "result": [ { "company.name": "This is the Company Name", "assigned_to.name": "The person assigned" } ] }

    For the Translation Map I am using the following: "company": "$.result[0].company.name", "assignedto": "$.result[0].assignedto.name"

    I am sure this has something to do with the "dot" in the name. Is there anything I can do to leverage that?

    Jason_Mathison | 2022-03-14 15:19:12 UTC | #2

    Hi Egill,

    You are correct that the . in the name was causing you trouble. Try this: $.result[0]["company.name"]

    --Jason

    Egill_Palsson | 2022-03-14 15:53:55 UTC | #3

    Thanks Jason,

    I had tried this, but then I get an error that the "JSON is not valid". If I use the double quotes.

    However if I change it to single quotes "$.result[0]['company.name']", then it WORKS!!!! I was so sure I had tried that at one point or another, but I guess not :slight_smile:

    Thanks so much for your help on this. Case closed :slight_smile:

    system | 2022-04-14 15:54:39 UTC | #4

    This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.

    This post was migrated from the old Developer Forum.

    ref: 13907



Related Content