Due to the lack of a modern calendar interface and corporate restrictions on what we can do within the sites, I am trying to create a feed that copies the calendar calendar entries ; a collection of sites to another.
At first I tried to use the information on the trigger element created / modified to create the new calendar entries, but there are hidden columns that are not available throw this interface (to get or define the newly created element), so I had to go to Send an HTTP request to SharePoint step to get all the columns I need. It seems to be working and I get json's like this.
"Title": "Simple single event",
Description goes here!",
I follow up on the request with a Analyze JSON and I used this tutorial to modify the schema and convert the values to appropriate types or accept no values or no. When I run a test, the output body of the analysis looks right to me. I see what I have above and I now have access to dynamic variables. It just seems to me because things that are strings are in quotes, numbers and booleans have no quotes and are blue, the same with null.
My problem comes from trying to use this JSON data parsed with a REST POST to create a new item. Using the dynamic data names analyzed by the previous steps, the strings I create a body like this.
I have to add quotes for those I know will be strings, but for Booleans (fAllDayEvent or fRecurrence) I don't see that false is changed to False. And for those who might be zero, I don't know what to do. I want to pass
null and not
"null". But at other times, nulls can actually be strings and at this point, they must have quotes.
I can't find anything to help you because all the research comes back to analyzing json. And that may be the solution, but I don't see how.
Any idea how to pass the parsed JSON value to a REST POST creative element endpoint when it can be zero, string, or number depending on?