Deal with quotation marks in HTTP request

How To
,
1

Hi Make Community,

I make a scenario to update an item into Airfocus (trigger : webhook).

I use Iterate Array and Aggregate Array (I tried with Text Aggregator, same problem) to deal with array in the JSON. But when the array is empty on the original item (trigger), the output is -“”- (double quotation marks).

This value is then used in an HTTP request but -“”- is not accepted.

How can I deal with this -“”- ?

Thank you in advance

Iterate Array input

[
    {
        "array": []
    }
]

Iterate Array output & Text Aggregator input

[]

Text Aggregator output

[
    {
        "text": ""
    }
]

HTTP Request input

\"assigneeUserGroupIds\":[\"\"]

(extract, not the all request input)

3

You are probably using the wrong aggregator. You can try using the JSON “Aggregate to JSON” module.

Alternatively, you can first aggregate to ARRAY, but then you will still need to use the JSON “Transform to JSON” module with the array.

For more information about the Aggregate to JSON and Transform to JSON modules, and JSON app, see the corresponding Integrations page and the Help Centre documentation.

Hope this helps! If you are still having trouble, please provide more details.

— @samliew

4

Hi samliew

Thank you for your help ! I try with Aggregate to JSON, but maybe the wrong way…

I will give you some additional informations that could help.

Trigger : Webhook (when an item is created)

[
    {
        "value": "{\"event\":{\"id\":\"a6adf67d-abef-466a-b3db-1847bdcc593a\",\"initiator\":{\"userId\":\"0a7f6eb7-d782-4d3a-930c-746a30a825f4\"},\"data\":{\"itemId\":\"1990cf64-d32a-4dc0-b801-5bd2c2cd899a\",\"status\":{\"next\":\"988fcefb-e684-4ece-9a40-d0ce074d382f\"},\"color\":{\"next\":\"amber\"},\"assigneeUserIds\":{\"next\":[\"0a7f6eb7-d782-4d3a-930c-746a30a825f4\",\"0dae97a6-5493-422d-a8cd-87d7f9bd4a22\"]},\"assigneeUserGroupIds\":{\"next\":[]},\"name\":{\"next\":\"TEST RHK Mise en forme simple (copy)\"},\"description\":{\"next\":{\"blocks\":[{\"content\":[{\"content\":\"Texte simple\",\"type\":\"text\"}],\"type\":\"paragraph\"}],\"richText\":true}},\"fields\":{\"cd401dea-5438-43be-abf7-e94e49b6e37b\":{\"next\":{\"text\":\"Ceci est le lien\"}},\"ef6eb46f-4716-4d59-9a35-550f1aee7d4a\":{\"next\":{\"selection\":[\"cbfbb3dd-3daa-41e9-bfd4-381e29629554\"]}},\"01ce4824-98e6-42fc-b3ca-d05b6aa98f49\":{\"next\":{\"selection\":[\"09ffea7e-586e-402f-b447-7deae34ad7aa\"]}},\"f60329a0-4318-4de9-a3b5-c340a9ab31bc\":{\"next\":{\"selection\":[\"67c4e29e-f5f6-41e2-88dd-63391fa8f324\",\"79d59da3-31be-4fdf-bfc6-757c08ba9924\"]}},\"0fc3157b-c658-4325-ac5f-ea1295356e82\":{\"next\":{\"selection\":[\"bdc66acb-326e-4212-82c5-cf9e0daeb321\"]}},\"e300eb7f-e6c7-4789-9e3e-c37c0d4e35c9\":{\"next\":{\"selection\":[\"43c31da4-a12d-4e0e-bd19-bbb046ac073d\",\"b3d44785-d9a8-4aca-a007-c20fabcbbf30\"]}},\"0f6c72a7-5255-4853-b36b-81d2e482a448\":{\"next\":{\"selection\":[\"7892f73a-010b-443b-97ff-4b88259b2e8c\"]}},\"6cf5e58f-fb8f-4df0-bd2b-204db5a47d90\":{\"next\":{\"userIds\":[\"0a7f6eb7-d782-4d3a-930c-746a30a825f4\",\"0dae97a6-5493-422d-a8cd-87d7f9bd4a22\"],\"userGroupIds\":[]}},\"670955af-1f55-4e12-a6c9-e43e2faca743\":{\"next\":{\"selection\":[\"7999de80-0476-369e-8067-d2caa039bd50\",\"0972c592-9b65-33a6-8f97-71a740541eff\"]}},\"e1f90e90-2783-44c8-a286-8d4a93d74b62\":{\"next\":{\"selection\":[\"0684dd84-2dc6-4989-8fa6-94241cb2e1ab\"]}},\"c7f583a0-583a-417b-9746-ada5160ff789\":{\"next\":{\"text\":\"Ceci est l'établissement\"}},\"f14acc12-d440-4f19-9ab1-bd5d45ee2e5d\":{\"next\":{\"selection\":[\"1f44ceb4-6a60-4ac8-8de4-4dc09cc8892c\",\"5c47cdba-969f-48e7-8af3-384067dfe49b\"]}},\"18a0f782-22cb-400d-96cf-3725c9801927\":{\"next\":{\"selection\":[\"1be3f014-9aa2-4a01-854f-47799f626803\"]}},\"f86a9bb7-be26-41e7-9c43-d7e1b4ff267d\":{\"next\":{\"selection\":[\"57d8fe40-2de8-4b11-b001-cc6cae895402\",\"a08be32c-9b6c-4f1b-85a9-5d7eac14aed4\"]}},\"68a52adb-a6b8-43cf-9891-aedfd31794e1\":{\"next\":{\"selection\":[\"56f18144-6f36-4154-80f6-ae421ebe0d3d\",\"d5d54b09-34da-4847-8fe0-d305a85e64c1\"]}},\"fe30c17c-1ea3-44b5-b088-c2b7139b1653\":{\"next\":{\"selection\":[]}}},\"archived\":{\"next\":false},\"reason\":{\"type\":\"copied\"},\"type\":\"createdItem\"},\"createdAt\":\"2025-11-05T14:21:32.332278191Z\"},\"embed\":{\"watchers\":[\"0a7f6eb7-d782-4d3a-930c-746a30a825f4\"],\"teams\":{\"8c110fff-ae36-4569-99bb-f4c308c1ec0b\":{\"name\":\"Incotec\",\"slug\":\"incotec\",\"baseUrl\":\"https://incotec.airfocus.com\"}},\"users\":{\"0a7f6eb7-d782-4d3a-930c-746a30a825f4\":{\"teamId\":\"8c110fff-ae36-4569-99bb-f4c308c1ec0b\",\"fullName\":\"Romain\"}},\"userGroups\":{\"4e77b4f4-6642-4e99-906b-ee5d8a0e785f\":{\"teamId\":\"8c110fff-ae36-4569-99bb-f4c308c1ec0b\",\"name\":\"Roadmap - Full permission\"},\"6c0510ec-cd30-4188-acc5-a0be68c6e71b\":{\"teamId\":\"8c110fff-ae36-4569-99bb-f4c308c1ec0b\",\"name\":\"Planification - Full permission\"},\"02f4fb4e-aa1a-41bd-8a21-a5b6dd818971\":{\"teamId\":\"8c110fff-ae36-4569-99bb-f4c308c1ec0b\",\"name\":\"Gestion des temps - Full permission\"}},\"workspaces\":{\"29172f9c-a0dc-4d81-98d8-39634e0c31d8\":{\"teamId\":\"8c110fff-ae36-4569-99bb-f4c308c1ec0b\",\"name\":\"Test Romain\",\"alias\":\"FD\"}},\"statuses\":{\"988fcefb-e684-4ece-9a40-d0ce074d382f\":{\"workspaceId\":\"29172f9c-a0dc-4d81-98d8-39634e0c31d8\",\"name\":\"Nouveau\",\"category\":\"draft\",\"color\":\"daulphine\"}},\"items\":{\"1990cf64-d32a-4dc0-b801-5bd2c2cd899a\":{\"workspaceId\":\"29172f9c-a0dc-4d81-98d8-39634e0c31d8\",\"statusId\":\"988fcefb-e684-4ece-9a40-d0ce074d382f\",\"name\":\"TEST RHK Mise en forme simple (copy)\",\"aliasNumber\":359,\"description\":{\"blocks\":[{\"content\":[{\"content\":\"Texte simple\",\"type\":\"text\"}],\"type\":\"paragraph\"}],\"richText\":true}}}},\"matchedFilter\":{\"type\":\"itemCreated\"}}"
    }
]

I want to update some fields of this same item, via a HTTP request.

But I don’t know how to transform the webhook output to a correct JSON format…

Request body ( Endpoints ) :

{
  "statusId": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
  "assigneeUserIds": [
    "3fa85f64-5717-4562-b3fc-2c963f66afa6"
  ],
  "assigneeUserGroupIds": [
    "3fa85f64-5717-4562-b3fc-2c963f66afa6"
  ],
  "name": "string",
  "description": {
    "blocks": [
      {
        "content": [
          {
            "content": "hello world",
            "type": "text"
          }
        ],
        "type": "paragraph"
      }
    ],
    "richText": true
  },
  "archived": false,
  "color": "amber",
  "fields": {
    "0fc3cfbc-27e9-3ea6-8a78-7de13dae3e3c": {
      "number": 42
    },
    "34f05b62-dd43-3e1e-82bc-b0acabd0d004": {
      "boolean": true
    },
    "5396681e-ea50-3d63-9ae3-c9f8ca17b7d8": {
      "userGroupIds": [
        "70e2b87a-b774-3022-9ef0-e55031a1c4fb"
      ],
      "userIds": [
        "24c9e15e-52af-347c-a25b-757e7bee1f9d"
      ]
    },
    "75fe57ec-4a04-3a30-8cac-5f27223df81a": {
      "dateRange": {
        "endDate": "2024-02-14",
        "startDate": "2024-01-14",
        "timezone": "UTC"
      }
    },
    "8be74552-df93-331b-bdd6-b36ed74bdb6a": {
      "selection": [
        "2bb225ce-b5ee-3493-967c-fde0d72da242"
      ]
    },
    "c7824f3d-4d5f-3b2f-a2d0-34758c1e9454": {
      "text": "A platform built for the new way of doing product management"
    },
    "e34d514f-7db5-38aa-872a-7c8191a09617": {
      "date": {
        "date": "2024-01-01",
        "timezone": "UTC"
      }
    }
  },
  "order": 1073741824
}
5

In your case it’s just a remapping into a different data structure, so you could definitely try the JSON “Create JSON” module.

Screenshot 2025-11-06 152444
Screenshot 2025-11-06 152444873×461 39.7 KB

Then you can map arrays like this:

Screenshot 2025-11-06 153043
Screenshot 2025-11-06 153043715×218 11.8 KB

Hope this helps! If you are still having trouble, please provide more details.

— @samliew

1 Like