Data360 Govern

When I GET a data quality rule from Govern using the API the Threshold for the rule is not returned as a standard field - see return body below. Is it possible to access the Threshold value as I wish to use this elsewhere?

i see in the configuration that this is not a standard field for a DQ Rule type. But I can edit this in the user fields so I am confused..

{ "items": [ { "AssetId": 265, "AssetUid": "65c426d2-31d7-4d01-8979-25371529e6ad", "AssetTypeId": 8, "AssetTypeUid": "152953f9-ea4b-4400-b4e7-69c9be2d9b27", "UpdatedOn": "2021-02-02T12:30:11.090Z", "CreatedOn": "2019-03-06T17:03:39.627Z", "Color": null, "Path": "[Conformity]", "LinktoRule": "Validity Rule|https://sagacity-uat.infogix.com/desktop/index.html?tenantId=personademo#pipeline/31169", "Name": "Conformity", "LinktoRuleText": null, "Description": "<p>xx</p>", "LinktoDashboard": "Data Quality Dashboard|https://sagacity-uat.infogix.com/desktop/index.html?tenantId=personademo#viewdashboard/43519", "Dimension": "Conformity", "Status": "", "TrilliumRuleID": null, "Priority": "Priority 10" },

Hi Gary,

Thanks for your post.  I understand the confusion.  The Threshold field on a Rule is going to be retired shortly, that's why it's not available in the API, but yet still visible and editable via the UI.  

If there is a use case you are working on in which you require this field please let me know the details.

Thank you,

Mandy Bank

Product Management

I am doing an integration to an external DQ tool that uses this value - but I can add a custom field. Thanks for the feedback

Great, that's exactly what I would recommend.

Thanks!

Mandy

HI Mandy.

trying to add a dq rule via swagger I get the following response:

[ { "ItemNumber": 1, "uid": "00000000-0000-0000-0000-000000000000", "Message": "Asset is missing a required Threshold field value", "Success": false } ]

So the threshold value seems still to be required but inaccessible via the API.

I had to switch off all other mandatory fields in order to see this response

Hi Gary,

Yep, that doesn't make much sense does it?  You need to POST it but you can't GET it.

That being said we're looking at removing it sooner rather than later, so if you can tolerate it for the next month or so I'll keep you posted when it's removed altogether.  In the meantime, use the custom field you created and possibly just put any number, maybe a default of 1, in the required Threshold field.  

Thanks,
Mandy

HI Mandy

Even if I add a Threshold value to my body (as per below) I still get the error "Asset is missing a required Threshold field value"

curl -X POST --header 'Content-Type: application/json' --header 'Accept: application/json' -d '[ \ 
  { \ 
       "Threshold": "1.0", \ 
       "Name": "Test", \ 
       "Description": "TEST1 ", \ 
       "Priority": "Priority 10" \ 
     } \ 
 ]' 'https://masterdatapoc.dev.data3sixty.com/api/v2/assets/152953f9-ea4b-4400-b4e7-69c9be2d9b27'

Hi Gary,

That doesn't sound right, I'm going to have Support take a look at that.  We'll respond in this thread.

Thanks,

Mandy

<x-zendesk-user data-user-name="Suhas Kotha">365021274968</x-zendesk-user>  please take a look at this issue.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Hello Gary,

Your Structure is wrong. Please check the screen print and payload

curl -X POST --header 'Content-Type: application/json' --header 'Accept: application/json' -d '[ \
   { \
     "Fields": { \
       "Threshold": 1.0, \
       "Name": "Test", \
       "Description": "TEST1", \
       "Priority":"Priority 10" \
     } \
   } \
 ]' 'https://masterdatapoc.dev.data3sixty.com/api/v2/assets/152953f9-ea4b-4400-b4e7-69c9be2d9b27?triggersWorkflow=false'

Thanks. Sorted. Not sure why it was not giving me a JSON error but appreciate it