Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Test_Nature Record Type

Request Demo

Hi - 

I am trying to extract data from the SOX module using the API Get Records by Type (GET https://api.app.wdesk.com/graphdb/v1/types/).  The API response for record type "Test_Nature" only provided me with the unique values of the test nature (see attached image), and limits the ability for me to relate/join this table to another table or report (i.e., Controls listing).  Is there any other record type or report that provides the values of test nature, which would allow me to relate it with other tables/reports?  Would be nice if the table includes the Control id.

Output for Record Type: Test_Nature

0

Comments

4 comments

Date Votes
  • Michael Lerch

    Hi Mark!  I'm excited to hear you are diving into our APIs.  Most of our users tie Test_Nature to Test_of_Control records rather than directly to Control.  You may have a Testing Summary or a Test Matrix report that covers the Testing information including Test_Nature.  If not, such a report could be built in your account, or an existing report could be supplemented with a column for testing nature.  If you use our records API endpoint and include incoming and outgoing relationships, you can probably find which Test_of_Control records each Test_Nature is tied to.

    0
  • Mark Isla
    • Edited

    How do I get that information with the incoming and outgoing relationships?  The Test_Nature record type has these information.  Do I just call the outgoing url like a GET API?

    {
    "id" : "Test_Nature",
    "type" : "type",
    "links" : {
    "self" : "https://api.wk-dev.wdesk.org/graphdb/v1/types/Test_Nature"
    },
    "attributes" : {
    "properties" : [ "value", "description" ]
    },
    "relationships" : {
    "outgoing" : {
    "links" : {
    "self" : "https://api.wk-dev.wdesk.org/graphdb/v1/types/Test_Nature/relationships/outgoing",
    "related" : "https://api.wk-dev.wdesk.org/graphdb/v1/types/Test_Nature/outgoing"
    }
    },
    "incoming" : {
    "links" : {
    "self" : "https://api.wk-dev.wdesk.org/graphdb/v1/types/Test_Nature/relationships/incoming",
    "related" : "https://api.wk-dev.wdesk.org/graphdb/v1/types/Test_Nature/incoming"
    }
    }
    }

    0
  • Michael Lerch

    Mark, for types, you can see the available relationships with something like `/graphdb/v1/types/Test_Nature?include=incoming,outgoing`  -- the json will now return data > meta > relationships and you'll see there's a relationship available between Test_of_Control and Test_Nature called "test_nature"

    When actually returning records, you can hit `graphdb/v1/records?filter[@type][EQ]=Test_Nature?include=incoming,outgoing`.  The output is a little noisy (we are working on tidying it up), but should have what you need. 

    0
  • Mark Isla

    Thank you - that worked, but I think it should be '&include=incoming,outgoing' rather than '?'

    0

Please sign in to leave a comment.