I'm adding dynamic content to the body of an http request.
The body is json formatted.
When I add the data manually it works fine. However when I add dynamic content it get's a malformed error.
The problem seems to be a number that I'm retrieving from a sharepoint list. In the return output it appears as a green number (no quotation marks).
Code:
Output:
Can anyone help?
I've tried writing the above json to a string using Set Variable - this worked. But I'd really like to understand why the green number format is not working.
Thanks
Solved! Go to Solution.
Hey @sam_new_zealand
Can you please perform the test below
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.
Hey @sam_new_zealand
Can you please perform the test below
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.
Hi,
Thanks for the suggestion. Unfortunately, it didn't change the nature of the json - same problem:
Sorry CFernandes, it requires credentials. As I said, I got it working, but only by writing the json directly with static data. As soon as I used dynamic data it fails.
I DID get it to work using Set Variable as this explicitly allows you to specify the output as string. But this seems very convoluted.
User | Count |
---|---|
27 | |
16 | |
15 | |
12 | |
10 |
User | Count |
---|---|
43 | |
30 | |
27 | |
24 | |
23 |