Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

script editor - Hanging on reload

We are trying to pull data from Service Now using the Rest Connector
Pull data for base table and sub-tables and Create a QVD
It hangs mid way
This was working fine till 3 weeks ago

REST Connector  - Hanging on reload


QV_issue.jpg




JOIN

join

[assigned_to]:

LOAD [display_value_u7] as assigned_to,

[link_u7] as assigned_to_link,

[__FK_assigned_to] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_assigned_to]);

join

[assignment_group]:

LOAD [display_value_u4] as assignment_group,

[link_u4] as assignment_group_link,

[__FK_assignment_group] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_assignment_group]);

join

[caller_id]:

LOAD [display_value_u3] as caller_id,

[link_u3] as caller_id_link,

[__FK_caller_id] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_caller_id]);

join

[closed_by]:

LOAD [display_value_u5] as closed_by,

[link_u5] as closed_by_link,

[__FK_closed_by] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_closed_by]);

join

[cmdb_ci]:

LOAD [display_value_u2] as cmdb_ci,

[link_u2] as cmdb_ci_link,

[__FK_cmdb_ci] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_cmdb_ci]);

join

[company]:

LOAD [display_value_u6] as company,

[link_u6] as company_link,

[__FK_company] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_company]);

join

[location]:

LOAD [display_value_u8] as location,

[link_u8] as location_link,

[__FK_location] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_location]);

join

[opened_by]:

LOAD [display_value_u0] as opened_by,

[link_u0] as opened_by_link,

[__FK_opened_by] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_opened_by]);

join

[resolved_by]:

LOAD [display_value] as resolved_by,

[link] as resolved_by_link,

[__FK_resolved_by] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_resolved_by]);

join

[rfc]:

LOAD [display_value_u9] as rfc,

[link_u9] as rfc_link,

[__FK_rfc] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_rfc]);

join

[sys_domain]:

LOAD [display_value_u1] as sys_domain,

[link_u1] as sys_domain_link,

[__FK_sys_domain] AS [__KEY_result]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_sys_domain]);

0 Replies