Forum Discussion

Bessonnizza's avatar
Bessonnizza
Helper II
6 years ago
Solved

Json.FromValue

Hello there,   I want to write POST request with data for WEB service. I try to use Json.FromValue function to convert to JSON, but it isn't working.   JSON data schema:   My POST request...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    ImkeF  yes, Json.FromValue works.

     

     

    data = Json.FromValue([ Period = [ Begin = paramBegin , End = paramEnd ],TargetObject = [ ObjectId = paramObjectId ,ObjectTypeId = paramObjectTypeId ]])

     

ImkeF's avatar
ImkeF
Community Champion
6 years ago

Hi Bessonnizza ,

I see no reason why Json.FromValue should not work.

Please try the following:

 

Json.FromValue(
    [
        Period = [
            Begin = "1584428676205",
            End = "1584515076205"
        ],
        TargetObject = [
            ObjectID = "51005",
            ObjectTypeId = "0F1E3A4A-88F5-4166-9BE8-76033DD85D08"
        ]
    ]
)

 

lbendlin's avatar
lbendlin
Super User
6 years ago

Either try Text.ToBinary  or encode the text with Base64 before feeding it to the Binary.FromText function.

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    ImkeF  yes, Json.FromValue works.

     

     

    data = Json.FromValue([ Period = [ Begin = paramBegin , End = paramEnd ],TargetObject = [ ObjectId = paramObjectId ,ObjectTypeId = paramObjectTypeId ]])

     

  • ImkeF's avatar
    ImkeF
    Community Champion
    6 years ago

    Hi lbendlin ,

    is there any specific reason why you're not working with the Json.FromValue function?
    To my understanding it is just the fitting function here and doesn't require all this escaping that can quickly lead to errors.

     

    The Json.FromValue function also allows for different encodings in the optional 2nd parameter.

     

     

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    ImkeF  No particular reason. I haven't worked with HTTP POST  much yet in the web.contents connector.  It's on my list of things to learn.