Error Handling in M

Stharwani — Wed, 12 Jul 2017 07:43:06 GMT

Hello,

I am building a Custom Connector to get data from a web sevrice. There are instances where the data would be null. Is tehre any error handling mechanism where it if it runs into an error, it can skip it and move on. Like Try catch?

Re: Error Handling in M

Eric_Zhang — Thu, 13 Jul 2017 07:05:59 GMT

@Stharwani wrote:

Hello,

I am building a Custom Connector to get data from a web sevrice. There are instances where the data would be null. Is tehre any error handling mechanism where it if it runs into an error, it can skip it and move on. Like Try catch?

@Stharwani

I'm not a M master, but based on my test, there's some error handling mechanism in M, at least the "try" word works some way. The M code below processes to last step though there's error midway.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlSK1YlWSgKTyUqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
    //change the type of an non-existing column
    #"Changed Type1" = try Table.TransformColumnTypes(#"Changed Type",{{"addAnewCol", Int64.Type}}),
    #"Final result" = #"Changed Type"
in
    #"Final result"

Could you be more specifc on your scenario, what kind of web service? I think you might add a check null step.

topic Re: Error Handling in M in Developer

Error Handling in M

Re: Error Handling in M