GET api/store/{id}/replication/peek?limit={limit}
Request Information
URI Parameters
Name | Description | Type | Additional information |
---|---|---|---|
id | integer |
Required |
|
limit | integer |
Default value is 1000 |
Body Parameters
None.
Response Information
Resource Description
Collection of ReplicationCommandName | Description | Type | Additional information |
---|---|---|---|
ID |
Unique identifier for the command |
globally unique identifier |
None. |
Sql |
SQL command text |
string |
None. |
SqlHash |
SQL command hash |
string |
None. |
Transaction |
When set, this groups the ReplicationCommand as part of a batch |
ReplicationTransaction |
None. |
Parameters |
SQL parameters - dict, POCO or anonymous type |
Object |
None. |
ReplicationParameters |
SQL Parameters - serialisable |
Dictionary of string [key] and ReplicationParameter [value] |
None. |
EmptyParameters | boolean |
None. |
|
Targets |
List of Targets |
Collection of globally unique identifier |
None. |
Created |
Date the command was created |
date |
None. |
CreatedTimestamp | integer |
None. |
Response Formats
application/json, text/json
Sample:
[ { "$id": "1", "id": "84e2caf4-36f4-4250-9475-4f99ca8d3392", "sql": "sample string 2", "sqlHash": "sample string 3", "transaction": { "$id": "2", "id": "2c3ff0e8-b953-4456-9dba-a620f7f52c06", "dataSource": "d96c353e-7e0e-483b-867e-97e911dc500a", "sourceIDs": [ 1, 2 ] }, "parameters": { "$id": "3" }, "replicationParameters": { "$id": "4", "sample string 1": { "$id": "5" }, "sample string 2": { "$id": "6" } }, "emptyParameters": true, "targets": [ "95feffa4-b764-4b27-baec-157e8c91af15", "dedc114d-b5bd-49ba-8253-320bf601a4c5" ], "created": "2025-10-05T00:03:56.8141436", "createdTimestamp": 7 }, { "$ref": "1" } ]
application/xml, text/xml
Sample:
<ArrayOfReplicationCommand xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EziManager.Models.Tenancies.Replication"> <ReplicationCommand> <Created>2025-10-05T00:03:56.8141436+00:00</Created> <CreatedTimestamp>7</CreatedTimestamp> <EmptyParameters>true</EmptyParameters> <ID>84e2caf4-36f4-4250-9475-4f99ca8d3392</ID> <Parameters /> <ReplicationParameters xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <d3p1:KeyValueOfstringReplicationParameterOT8kAyz1> <d3p1:Key>sample string 1</d3p1:Key> <d3p1:Value /> </d3p1:KeyValueOfstringReplicationParameterOT8kAyz1> <d3p1:KeyValueOfstringReplicationParameterOT8kAyz1> <d3p1:Key>sample string 2</d3p1:Key> <d3p1:Value /> </d3p1:KeyValueOfstringReplicationParameterOT8kAyz1> </ReplicationParameters> <Sql>sample string 2</Sql> <SqlHash>sample string 3</SqlHash> <Targets xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <d3p1:guid>95feffa4-b764-4b27-baec-157e8c91af15</d3p1:guid> <d3p1:guid>dedc114d-b5bd-49ba-8253-320bf601a4c5</d3p1:guid> </Targets> <Transaction> <DataSource>d96c353e-7e0e-483b-867e-97e911dc500a</DataSource> <ID>2c3ff0e8-b953-4456-9dba-a620f7f52c06</ID> <SourceIDs xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <d4p1:int>1</d4p1:int> <d4p1:int>2</d4p1:int> </SourceIDs> </Transaction> </ReplicationCommand> <ReplicationCommand> <Created>2025-10-05T00:03:56.8141436+00:00</Created> <CreatedTimestamp>7</CreatedTimestamp> <EmptyParameters>true</EmptyParameters> <ID>84e2caf4-36f4-4250-9475-4f99ca8d3392</ID> <Parameters /> <ReplicationParameters xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <d3p1:KeyValueOfstringReplicationParameterOT8kAyz1> <d3p1:Key>sample string 1</d3p1:Key> <d3p1:Value /> </d3p1:KeyValueOfstringReplicationParameterOT8kAyz1> <d3p1:KeyValueOfstringReplicationParameterOT8kAyz1> <d3p1:Key>sample string 2</d3p1:Key> <d3p1:Value /> </d3p1:KeyValueOfstringReplicationParameterOT8kAyz1> </ReplicationParameters> <Sql>sample string 2</Sql> <SqlHash>sample string 3</SqlHash> <Targets xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <d3p1:guid>95feffa4-b764-4b27-baec-157e8c91af15</d3p1:guid> <d3p1:guid>dedc114d-b5bd-49ba-8253-320bf601a4c5</d3p1:guid> </Targets> <Transaction> <DataSource>d96c353e-7e0e-483b-867e-97e911dc500a</DataSource> <ID>2c3ff0e8-b953-4456-9dba-a620f7f52c06</ID> <SourceIDs xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <d4p1:int>1</d4p1:int> <d4p1:int>2</d4p1:int> </SourceIDs> </Transaction> </ReplicationCommand> </ArrayOfReplicationCommand>
text/csv
Sample:
Sample not available.
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Sample:
PK | E[�g � 5 xl/workbook.xml � (� ����0��&�C���J")��x��-�4П�5���H�yۙ��v�l�ȍ�GM�W��C�"ċ�'cA�]o�b!J�"�鹿ֈ�H�e%q0� ������X�:`� ��V�bR��x@�.͞f�d4�����"�)�`�ERH35nY`%���8��U2�W^�B\�s�w��d��|PK | E[���� � [Content_Types].xml � (� ���J�0�_��*M�D��V�*��d� �d�k��<�H���V���= ��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ �1Z�$�8z�R��3 tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b ��%#H'�2}���e�B)��~j/F�t��PK | E[,�i' ' _rels/.rels � (� <?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="Rf191e45ab2f14530" /></Relationships>PK | E[�zcW D xl/worksheets/sheet1.xml � (� ��Ks�0F��G��z?2@&m�&Yu�h�.��l1�����X�@��G��:\���f��i�j���!�t�4��}���_��v1���*�}����9�����[V�)]n�� {kc�҇K�R���^�{��5����VoJZ���:p���Znku��n��K5e݂�lU�ꇻϬ^���y& +��]�;[g���5��p�ر�~����J�����2�G]�T>Hb]fi6�{͚��dM��땯怈KN�RT)�0Ȗ;�M�縍>����S�\0H!��K)��I�'���}���L�3�8G�3L.�Y�g���D� s,.�y��C�\)�$��qN/�E�C^���TJJC~����rȓ\��q���W}^ y�KE�@�!Ɗ]�#�1@p� s���JI��8b7���/3k���C���.,]7�a|]�Ҽ-�x;d{��@c�۔�c�~J�1�}J�1�0%ؘ�1%��x�bL<M 9&���:E|���x�0֜@b� $�@b� $V�@b� $��@b�H�y3EX!*�c��H'�pr]x��'�Xx��'�Xx��'�Xx����'�gϔ*��j�`�{��,�PK | E[��� P xl/_rels/workbook.xml.rels � (� ��Kn�0@�b;��!D`æ[�{�D$vdZ��E��+ԢRk�.�a5��ӓf>�?6��y"�n4��4a@P#Gݷp�ꩆ�vs���0�qq$�h������ԉg���e��}HmO.N�G�1VR3�I���C4J��F�g��0}5��D��m��������&� �Y�p���]��T���K �aj�_'t�^�y$S�d��VS��2�(_� ����r�Vc#s̤�U�����_l� PK | E[Ѓc'2 E xl/styles.xml � (� �S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v �F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&� AR>��� ��im��ΑF���YO��%�}� ��LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PK | E[�HJ^ 5 xl/sharedStrings.xml � (� �RQO�0�+˞݆c �m<��D#�xv�V�v����[�2�&�4������ɻ�j�J�s��:�X�sU$�cv�\��D�0q�H�3Ic"�X���-��/��X�ȯjT�YWZ��O]Tk��JD#E�z�@W�êF��&i�48= 6Oc������q�{}!ˍ��*�p�A0c{kS��A������g�u]��l��t���Z�p�%Z�e��G�֑��# =o]�h=3���8lk��#ЎN�I:����>���E�� ?C�q$�ȟ��/^/�dP�w/��L9������9*Ԝ�3�@o���w�r_��? <L��tM�(k��|u$�ާ�PK- | E[�g � 5 xl/workbook.xmlPK- | E[���� � [Content_Types].xmlPK- | E[,�i' ' V _rels/.relsPK- | E[�zcW D � xl/worksheets/sheet1.xmlPK- | E[��� P k xl/_rels/workbook.xml.relsPK- | E[Ѓc'2 E � xl/styles.xmlPK- | E[�HJ^ 5 + xl/sharedStrings.xmlPK � �
application/vnd.ms-excel
Sample:
PK | E[tA��� 5 xl/workbook.xml � (� ����0D�&�C��P*N\�z��" �%m ~��o�vfg�N>k3�Z�#Ge3S�)c�6=J�'=��N �K�b��D��n��c<�Rfp'����,]i���dZ�#:9�( B��x $_�=�6Holu��5�~Sy��AZ�J�soSb2�G��oך'��/��;{��l�]~PK | E[���� � [Content_Types].xml � (� ���J�0�_��*M�D��V�*��d� �d�k��<�H���V���= ��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ �1Z�$�8z�R��3 tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b ��%#H'�2}���e�B)��~j/F�t��PK | E[|�ĭ' ' _rels/.rels � (� <?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="R289e18781cbe46eb" /></Relationships>PK | E[�zcW D xl/worksheets/sheet1.xml � (� ��Ks�0F��G��z?2@&m�&Yu�h�.��l1�����X�@��G��:\���f��i�j���!�t�4��}���_��v1���*�}����9�����[V�)]n�� {kc�҇K�R���^�{��5����VoJZ���:p���Znku��n��K5e݂�lU�ꇻϬ^���y& +��]�;[g���5��p�ر�~����J�����2�G]�T>Hb]fi6�{͚��dM��땯怈KN�RT)�0Ȗ;�M�縍>����S�\0H!��K)��I�'���}���L�3�8G�3L.�Y�g���D� s,.�y��C�\)�$��qN/�E�C^���TJJC~����rȓ\��q���W}^ y�KE�@�!Ɗ]�#�1@p� s���JI��8b7���/3k���C���.,]7�a|]�Ҽ-�x;d{��@c�۔�c�~J�1�}J�1�0%ؘ�1%��x�bL<M 9&���:E|���x�0֜@b� $�@b� $V�@b� $��@b�H�y3EX!*�c��H'�pr]x��'�Xx��'�Xx��'�Xx����'�gϔ*��j�`�{��,�PK | E[�f|�� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8qB⠦ݰa[z��Q;�]�gc���V� �X��j4��'�|�lvo�D^Ї���,�V:5ڡ�S�wv��'�D0�HZ����@i�g2��M��,bJ�@!�b@��~̀k&9���i=J|t�4������`#����~J�^B�%*�'��^������e�0��L-�����;_�ȾT�@������2FxT�ѧK����Z���l�{^ ��/j��/�_PK | E[Ѓc'2 E xl/styles.xml � (� �S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v �F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&� AR>��� ��im��ΑF���YO��%�}� ��LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PK | E[�HJ^ 5 xl/sharedStrings.xml � (� �RQO�0�+˞݆c �m<��D#�xv�V�v����[�2�&�4������ɻ�j�J�s��:�X�sU$�cv�\��D�0q�H�3Ic"�X���-��/��X�ȯjT�YWZ��O]Tk��JD#E�z�@W�êF��&i�48= 6Oc������q�{}!ˍ��*�p�A0c{kS��A������g�u]��l��t���Z�p�%Z�e��G�֑��# =o]�h=3���8lk��#ЎN�I:����>���E�� ?C�q$�ȟ��/^/�dP�w/��L9������9*Ԝ�3�@o���w�r_��? <L��tM�(k��|u$�ާ�PK- | E[tA��� 5 xl/workbook.xmlPK- | E[���� � [Content_Types].xmlPK- | E[|�ĭ' ' V _rels/.relsPK- | E[�zcW D � xl/worksheets/sheet1.xmlPK- | E[�f|�� P k xl/_rels/workbook.xml.relsPK- | E[Ѓc'2 E � xl/styles.xmlPK- | E[�HJ^ 5 * xl/sharedStrings.xmlPK � �