Data Factory Mapping Setting my int in JSON to True false

Question

Data Factory Mapping Setting my int in JSON to True false

Debbie Edwards 521

I have the following in JSON
"TypeId":1

And In data Factory Mapping its coming through as boolean (True flase) in the projection. And it should be an int

I can't find any way to change it to in in the source setting

But it made no difference. When I flatten in preview I get

How do I get past this issue? I need it to be integer not Boolean

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-07-12T04:39:26.717+00:00

Hello @Debbie Edwards ,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-07-13T21:31:10.977+00:00

Hello @Debbie Edwards ,

We still have not heard back from you. Just wanted to check if the below suggestion was helpful? If it answers your query, please do click Accept Answer and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

1 answer

Your answer

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-07-12T04:39:26.717+00:00

Hello @Debbie Edwards ,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-07-13T21:31:10.977+00:00

Hello @Debbie Edwards ,

We still have not heard back from you. Just wanted to check if the below suggestion was helpful? If it answers your query, please do click Accept Answer and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 1

Hello @Debbie Edwards ,

Thanks for the question and using MS Q&A platform.

As per my understanding your json data has a column of type interger value, but you see that as boolean under projection of your source in Data flow. Please correct me if I'm wrong.

If my understanding is correct correct, and if you would want to consider it as integer rather than a boolean,

Then you can use reset schema which would set the boolean value to integer
Another thing you can do is to click on overwrite schema option under projection tab of your source.

Step 1:

Option 1:

Reset schema:

Option 2:

Overwrite schema:

And then select integer data type for your column.

Hope this will help. Please let us know if any further queries or if your scenario is different that what I have assumed.
We look forward to your response.

Thank you

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Anuganti Suresh 200 Reputation points

2024-01-09T10:41:55.1733333+00:00

@KranthiPakala-MSFT , option 2 (Overwrite schema) will work for top level nested JSON. Suppose i want to change data type from boolean to integer for "verificationResult": 1?

[{ "_id": "abc" }, "no": "0403944", "Code": "TT", "products": [ "Key": "12345", "pName": "Amount", "pType": "05", "aType": "CHEQUING" "identity": { "_id": "763456", "VerificationResult": { "_id": "6525" }, "score": 80, "Assesment": "Kinder", "tId": "62986dcv" }, "fResult": { "_id": "abcdef" }, "score": 97, "Match": true, "tId": "98xcv345" }, "VerificationResult": 1 ]

Share via

Data Factory Mapping Setting my int in JSON to True false

1 answer

Your answer