Set Values is Null and set to json Value

(0) Share

Report

Posted on by twbook

I have a Initialize a for the mediaEditLink, is does not set set to the value in the JSON?

@body('Parse_Get_extensionUpload')?['extensionContent@odata.mediaEditLink']"

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I think the expression is not well formed.
Did you write the expression yourself or select the field from the dynamic field selector?
If you share the schema and content, I can try at my end.

Was this reply helpful? Yes No
twbook 2 on at

Like (0)

Report
Copy link

Link copied!

Selected the field from the dynamics filed selector

{
  "@odata.context": "https://api.businesscentral.dynamics.com/v2.0/Wombat/api/microsoft/automation/v2.0/$metadata#companies(a6929bbd-8188-4609-9508-f8b5788b7812)/extensionUpload",
  "value": [
    {
      "@odata.etag": "W/\"JzE5OzYwMjY4NzkwNzg0MDM5ODAwMzYxOzAwOyc=\"",
      "systemId": "69d11294-5443-ed11-946f-0022482856e5",
      "schedule": "Current_x0020_version",
      "extensionContent@odata.mediaEditLink": "https://api.businesscentral.dynamics.com/v2.0/Wombat/api/microsoft/automation/v2.0/companies(a6929bbd-8188-4609-9508-f8b5788b7812)/extensionUpload(69d11294-5443-ed11-946f-0022482856e5)/extensionContent",
      "extensionContent@odata.mediaReadLink": "https://api.businesscentral.dynamics.com/v2.0/Wombat/api/microsoft/automation/v2.0/companies(a6929bbd-8188-4609-9508-f8b5788b7812)/extensionUpload(69d11294-5443-ed11-946f-0022482856e5)/extensionContent"
    }
  ]
}

{
    "type": "object",
    "properties": {
        "@@odata.context": {
            "type": "string"
        },
        "@@odata.etag": {
            "type": "string"
        },
        "systemId": {
            "type": "string"
        },
        "schedule": {
            "type": "string"
        },
        "extensionContent@odata.mediaEditLink": {
            "type": "string"
        },
        "extensionContent@odata.mediaReadLink": {
            "type": "string"
        }
    }
}

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Your schema doesn't match the Data,

Try this schema.

{
  "type": "object",
  "properties": {
    "value": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "systemId": {
            "type": "string"
          },
          "schedule": {
            "type": "string"
          },
          "extensionContent@odata.mediaEditLink": {
            "type": "string"
          },
          "extensionContent@odata.mediaReadLink": {
            "type": "string"
          },
          "@odata.etag": {
            "type": "string"
          }
        },
        "required": [
          "@odata.etag",
          "systemId",
          "schedule",
          "extensionContent@odata.mediaEditLink",
          "extensionContent@odata.mediaReadLink"
        ]
      }
    },
    "@odata.context": {
      "type": "string"
    }
  }
}
The apply to each loop is there because you are supplying it with an array

Was this reply helpful? Yes No