Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are trying to pull data from Service Now using the Rest ConnectorPull data for base table and sub-tables and Create a QVDIt hangs mid wayThis was working fine till 3 weeks ago
REST Connector - Hanging on reload
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]);
[assignment_group]:
LOAD [display_value_u4] as assignment_group,
[link_u4] as assignment_group_link,
[__FK_assignment_group] AS [__KEY_result]
WHERE NOT IsNull([__FK_assignment_group]);
[caller_id]:
LOAD [display_value_u3] as caller_id,
[link_u3] as caller_id_link,
[__FK_caller_id] AS [__KEY_result]
WHERE NOT IsNull([__FK_caller_id]);
[closed_by]:
LOAD [display_value_u5] as closed_by,
[link_u5] as closed_by_link,
[__FK_closed_by] AS [__KEY_result]
WHERE NOT IsNull([__FK_closed_by]);
[cmdb_ci]:
LOAD [display_value_u2] as cmdb_ci,
[link_u2] as cmdb_ci_link,
[__FK_cmdb_ci] AS [__KEY_result]
WHERE NOT IsNull([__FK_cmdb_ci]);
[company]:
LOAD [display_value_u6] as company,
[link_u6] as company_link,
[__FK_company] AS [__KEY_result]
WHERE NOT IsNull([__FK_company]);
[location]:
LOAD [display_value_u8] as location,
[link_u8] as location_link,
[__FK_location] AS [__KEY_result]
WHERE NOT IsNull([__FK_location]);
[opened_by]:
LOAD [display_value_u0] as opened_by,
[link_u0] as opened_by_link,
[__FK_opened_by] AS [__KEY_result]
WHERE NOT IsNull([__FK_opened_by]);
[resolved_by]:
LOAD [display_value] as resolved_by,
[link] as resolved_by_link,
[__FK_resolved_by] AS [__KEY_result]
WHERE NOT IsNull([__FK_resolved_by]);
[rfc]:
LOAD [display_value_u9] as rfc,
[link_u9] as rfc_link,
[__FK_rfc] AS [__KEY_result]
WHERE NOT IsNull([__FK_rfc]);
[sys_domain]:
LOAD [display_value_u1] as sys_domain,
[link_u1] as sys_domain_link,
[__FK_sys_domain] AS [__KEY_result]
WHERE NOT IsNull([__FK_sys_domain]);