Power Platform Community Forum Thread Details

Hello,

I realise an interface between Sales And FinOps with DataIntegration functionnality.

For on off my task I need to use fetchXml for extract data from Sales

I use this stucture

[serveurSales]/api/data/v9.0/accounts?fetchXml=[XmlQuery]

The problem with this solution is that if the data not exists on Sales we don't have value to the result.
And the Schema don't correspond with the result.
For some columns DataIntegration set null value the column and for other column I have an Error

cf : ScreenError01

If I run the task I have this error

The powerquery job failed with error: Exception ExceptionType:MashupEvaluationException, ExceptionMessage:Expression.Error: The field 'telephone1' of the record wasn't found., EvaluationResponse:{"ResultType":"Exception","Message":"Expression.Error: The field 'telephone1' of the record wasn't found.","Errors":[],"EvaluationUsage":{"HourlyEvaluationCount":61,"DailyEvaluationTime":61820801,"HourlyEvaluationCountRemaining":939,"DailyEvaluationTimeRemaining":24579199}}, EvaluationUsage:{"HourlyEvaluationCount":61,"DailyEvaluationTime":61820801,"HourlyEvaluationCountRemaining":939,"DailyEvaluationTimeRemaining":24579199}

Someone know if it's possible to define a default value, or have an idea to resolve this problem

Thank's