Prepare Lisk Service v0.7.0 for rc

[sridharmeganathan]

Description

The purpose of this epic is to prepare the Lisk Service v0.7.0-rc.0 release

Tasks

• Create endpoint to list available tokenIDs #1256
• Create top balances endpoint #1566
• address unavailable in /blockchain/apps endpoint response #1582
• Index balances by address and tokenID #1383
• Fix Jenkins pipeline issue #809
• Fix api response inconsistencies #1597
• Update README #1600
• Blockchain application off-chain meta endpoint does not adhere to the limits #1609
• Extend support on search param #1565
• Update images for Lisk app-registry#25
• Improve GitHub Actions workflow app-registry#24
• Fix calcSelfStakeReward #1610
• meta unavailable in transactions/dryrun endpoint #1626
• Extend generators endpoint #1606
• Update proofOfPosession to proofOfPossession #1605
• Update Lisk SDK to v6.0.0-beta.1 #1639
• Validate invoke endpoint request params #1638
• Add transactions estimateFees endpoint #1573
• Cache immutable entities #1189
• Remove globalTokenID logic from transaction-statistics #1473
• Update unlocks endpoint #1642
• Fix revertTransaction hook for submitSidechainCrossChainUpdate transaction #1625
• Add validator rank validation job #1459
• Improve MySQL implementation #1188
• Make Access-Control-Allow-Origin configurable #1670
• Error querying metadata for supported tokens #1674
• Ease apk package pinning in Dockerfile #1662
• Add support/configure read-replicas for MySQL #1603
• Disable etag for selected endpoints #1637
• search parameter throws an error in Lisk Service APIs #1679
• Estimate fees endpoint does not support multisig transactions #1669
• Consider transaction execution status within the hooks #1678
• Extend currency support for market prices #1551
• Integrate account knowledge #1666
• Block ID present in pending transactions #1664
• Wrong calculation of validator's rank #1665
• Extend the top balances endpoint #1695
• getNetworkStatus from connector intermittently fails in indexer #1536
• Transaction statistics crashes #1527
• Unable to run benchmark for WS JSON-RPC API #1671
• Update microservice documentation #1684
• Update transaction fee estimates endpoint #1699
• Fix transaction statistics #1686
• HTTP rate limiting options are not passed to Gateway container #1711
• Update validators cache on changeCommission transaction #1713
• Unable to query pending transactions by address #1712
• ReDoS in API parameter validation #1710
• Incorrect transaction minFee/size #1604
• Fix knex timeout errors #1564
• Indexer crashes on validator endpoint call while indexing #1687
• HTTP rate limiter trusts X-Forwarded-For header from the client #1697
• Unhandled exception when filename for transaction history download is a directory #1716
• Update Lisk SDK to v6.0.0-beta.4 #1717
• Lack of MySQL LIKE escaping in search parameters #1731
• Add contributions information to the README app-registry#30
• Validate secured service URLs based on their certificate app-registry#31
• Update documentation #1732
• Update transaction exports processor #1116
• Update SDK to v6.0.0-beta.5 #1735
• Extend blockchain apps metadata endpoint response #1744
• Add support for MySQL snapshot in indexer #1742
• Integrate CodeQL to CI #1737
• Integrate Semgrep to CI #1736
• Update Pm2 commands in Lisk Service Docs #1705
• Update Configuration with Docker in Lisk Service Docs #1706
• Connector crashes on request timeouts #1758
• Dryrun does not validate properly with an invalid transaction #1763
• PR validation does not execute as intended app-registry#34
• Fix CI logo URL validation logic app-registry#37
• Cache token summary information in connector #1769
• Adjusting keepAliveTimeout for the moleculer-web server #1599
• Improve gateway test suite #1738
• Optimize command examples (Service) #1724
• Fix Semgrep reported issues #1760
• Fix CodeQL reported issues #1755
• Event logs not emitted when dry run fails #1762
• Inconsistent fees total amounts on /estimate-fees endpoint #1771
• Transaction minimum fee is wrongly calculated #1783
• Paginate missed blocks queries #1781
• Incorrect status for a punished delegate #1786
• Incorrect totalCommision value #1788
• Remove CCM schema from connector #1632
• Update Lisk Service Configuration Reference - Lisk Docs #1757
• Bump node version to 18 in setup guides #1768
• Update Lisk Service image build process #1775
• Update Lisk SDK to v6.0.0-beta.6 #1776
• Transaction estimate fees throws error for cross chain transfer transaction #1804
• Update Lisk SDK to v6.0.0-beta.7 #1809
• Update terminologies #1800
• Gateway does not return response on upstream service error #1817
• /token/summary returns incorrect response #1813
• No response on blockchain apps metadata endpoints  #1752
• Update transaction history export logic #1772
• Migrate from npm to yarn #1754
• Update Lisk SDK to v6.0.0-rc.0 #1840
• Fix incorrect min in all parameters in all APIs #1828
• Fix API documentation and swagger #1827
• Fix inconsistencies with POS APIs #1826
• Fix inconsistencies with blockchain apps APIs #1825
• Add endpoint to fetch NFT history by type attribute #1816