Automate

All,

I've marked several fields for reporting in my solution. When running the API I do get the fields but all values are 'null'. Anyone any ideas?

------------------------------
Joost Hogervorst | Senior Consultant
CTAC | +31 (0)73 692 0692
joost.hogervorst@ctac.nl
------------------------------

Hi Joost, 
I always use a testing tool like Postman to test my API calls. 
- I find the solution key http://mysever/dwapi/v1/dim/solutions?$filter=contains(Name,'Customer')   Fill in your server name and use a filter if you have a lot of processes) and get the solution key
- I review the form data captured: http://myserver/v1/forms/469  Fill in your server name and use the solution key number where I have 469

The only reasons I can think the form data is null:
- reporting db has not been synchronized
- instance of workflow was run before reporting db existed
- the values for those form fields are not yet filled in
- there's something off with the joining of data in the reporting tool

Hope this helps a little.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
pse | Winshuttle North America
------------------------------

Hi Sigrid,

We managed to solve the issue with the help of Winshuttle Support UK. Joining of data in the reporting tool was indeed the issue.

------------------------------
Joost Hogervorst | Senior Consultant
CTAC | +31 (0)73 692 0692
joost.hogervorst@ctac.nl
------------------------------

Original Message:
Sent: 12-20-2019 09:27
From: sigrid kok
Subject: Value 'null' in fields marked for reporting in API's generated by Data Reporting Warehouse

Hi Joost,
I always use a testing tool like Postman to test my API calls.
- I find the solution key http://mysever/dwapi/v1/dim/solutions?$filter=contains(Name,'Customer')   Fill in your server name and use a filter if you have a lot of processes) and get the solution key
- I review the form data captured: http://myserver/v1/forms/469  Fill in your server name and use the solution key number where I have 469

The only reasons I can think the form data is null:
- reporting db has not been synchronized
- instance of workflow was run before reporting db existed
- the values for those form fields are not yet filled in
- there's something off with the joining of data in the reporting tool

Hope this helps a little.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
pse | Winshuttle North America
------------------------------

Good to hear, Joost!

------------------------------
Sigrid Kok
winshuttle | Winshuttle North America
------------------------------

Original Message:
Sent: 01-16-2020 02:55
From: Joost Hogervorst
Subject: Value 'null' in fields marked for reporting in API's generated by Data Reporting Warehouse

Hi Sigrid,

We managed to solve the issue with the help of Winshuttle Support UK. Joining of data in the reporting tool was indeed the issue.

------------------------------
Joost Hogervorst | Senior Consultant
CTAC | +31 (0)73 692 0692
joost.hogervorst@ctac.nl
------------------------------


Original Message:
Sent: 12-20-2019 09:27
From: sigrid kok
Subject: Value 'null' in fields marked for reporting in API's generated by Data Reporting Warehouse

Hi Joost,
I always use a testing tool like Postman to test my API calls.
- I find the solution key http://mysever/dwapi/v1/dim/solutions?$filter=contains(Name,'Customer')   Fill in your server name and use a filter if you have a lot of processes) and get the solution key
- I review the form data captured: http://myserver/v1/forms/469  Fill in your server name and use the solution key number where I have 469

The only reasons I can think the form data is null:
- reporting db has not been synchronized
- instance of workflow was run before reporting db existed
- the values for those form fields are not yet filled in
- there's something off with the joining of data in the reporting tool

Hope this helps a little.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
pse | Winshuttle North America