Microsoft 365 Outlook

[AKuma510]

Hi @ewilson

I am using the microsoft Outlook 365 (Graph API) and while Downloading attachments from email Some I am getting Below errors:

1. Could not execute code stage because exception thrown by code stage: Column '@odata.mediaContentType' does not belong to table
2. Could not execute code stage because exception thrown by code stage: Column 'contentBytes' does not belong to table attachments

And for List Mails in Folder Action sometime its failing while converting JSON to Messages(Collection). Below is the error coming for the same:-

1. Internal : Could not execute code stage because exception thrown by code stage: Unable to cast object of type 'Newtonsoft.Json.Linq.JValue' to type 'Newtonsoft.Json.Linq.JObject'.

Please help me to know how these errors can be resolved.

------------------------------
Akshay Kumar Singh
------------------------------

[john.hammond]

Hi @ewilson - I'm just wondering if there's been an update to this issue? If it's any help, it appears to be generated at the point of the code stage 'JSON to Messages' within the action List Mail in Folder (Microsoft 365 - Outlook VBO). It appears to be the result of whenever a user has categorised any of the emails within the particular folder - asking the user(s) to remove the categorisation allowed the process to work as intended, but would obviously prefer to not have to instruct the business area to not categorise their own emails!

[arghya.b]

@ewilson is this issue resolve ? we are getting the same with the object v1.5

[arghya.b]

HI @AKuma510 able to save. Msg attachments using microsoft365 outlook ?

[nwilljackson]

Hi @ewilson,

Did you manage to find an answer to this issue after investigating?

I am facing the same issue with the JSON to Collection action.

[arghya.b]

Hi @nwilljackson  please download the Microsoft 365 - Outlook(vr 1.6.3) from DX and try.

The issue resolved in this version.

[nwilljackson]

Thanks @arghya.b 

I had this issue occur when working with another API. JSON to Collection could not parse the response content. I was getting the below error:

Could not execute code stage because exception thrown by code stage: Column '' does not belong to table .

I believe this error is occuring due to differences in the response content as Eric mentioned earlier in this thread.

I have found a solution. Instead of using JSON to Collection, I am using JSONPath - Return Collection - Using JArray. With this action I am defining the JSON path to the element I need and ignoring all other elements. I am itterating through multiple results by incrementing with a calc stage:

"$.results["&[Item Number]&"].XXX"